Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to add selections from Excel to applications

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 Replies
Not applicable

How to add selections from Excel to applications

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.

Not applicable

How to add selections from Excel to applications

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

The idea is that users can dynamicly change it.