2 Replies Latest reply: Apr 12, 2012 9:15 AM by Alexander Gonchar RSS

    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.