I need a basic dashboard created using QlikView. For DEMO (but using actual data).

1. I have four Excel files which are used to create one open order report. I would like to create a dashboard indicating the key data such as Past due items and items due in 1,2,3 weeks (by buyer, site etc). Also need some other simple calculations indicating margin etc. Probably 4 charts on the dashboard.

2. I have a number of excel files (about 7) with part codes and item descriptions and I need a simple dashboard to search for common items. Note common items will have different codes and the item descriptions is not an exact match so search facility should be able to filter letter groupings.

In both cases the output is for a demo so it just needs to be functional.