How to add selections from Excel to applications

[#1]

Hello.

I have a simle sales app, where we can find sales in about 5000 goods from 500 suppliers.

I have several exel files for goods and suppliers.

Sometimes I need to analyze about 100-200 items from different groups, which where on sale and goods from about 50 suppliers.

All this goods and suppliers are always different.

One of the ways is to select them manually in listboxes, but I would like to it in a more simple way.

All the goods and suppliers have the same name in Excel as in App.

What is the best way to connect this excel to QlikView in the fastest fastest way,

particial reload?

Users (not developers) should be able to do it themselves

The normal reload of the app takes for about 60 minutes.

[#2]

You need to move the different supplier sheets into QVD files ( I suggest you create a standard QVD format for all suplpiers)  and then reload the QVW form the different QVDs. If you create one QVD for each supplier then reload of individual suppliers will be very quick as they just update just their associated QVD.  Then you can load from QVD to the main applciation very quickly.

[#3]

not, it is not exactly what we want to do.

The idea is that users can dynamicly change it.