2 Replies Latest reply: Apr 23, 2014 10:30 AM by Patrick Gendron RSS

    Create and Save data in Qlikview

      Hi,

       

      As done in the below video

       

      QlikView ROI Calculator - 5000 User Scenario - YouTube

       

      Can you please guide to the right track (study material)  to generate and save data scenarios in the qlikview? It's great for generating multiple P/L forecasting scenarios, comparing and discussing them in a meeting room!

       

      Thanks in advance!

       

      BR,

      SAK

        • Re: Create and Save data in Qlikview

          Hi Shoaib,

           

          When I saw that video I thought exactly the same.

          I worked on a solution for quite a while, so I will share it with everyone here.

           

          Make sure that in document properties -> Server -> Enable push from server and Enable Dynamic Data Update are enabled!

           

          - First create variables for all inputfields that someone needs to fill in.

          - Create the input fields

          - Create a button, select actions -> Dynamic update (dynamic update will immediately add the specified data into your qlikview datamodel, no reloads required)

          - Select some more actions (if you want) like set variable: 0

          - Last action: Run Macro, this is to export a table to a .qvd file (the data is already in your qlikview, this is for storing)

           

          Make a chart, (straight table) with all the fields you want to store in the .qvd file (I recommend all of the same fields as in the dynamic update). And put this chartnumber (for example: CH01) in the macro.

          For this chart, it might be wise to put a conditional show in the

           

          Please see the example for more details!

          Scenarios.qvw

           

          Now the value of this approach is that you do not only have the scenarios in the qlikview, you also have them stored in a .qvd file! (you might want to use these in another qlikview, as backup or for next reloads).

           

          Hope this helps.

          With regards,

          JM

            • Re: Create and Save data in Qlikview
              Patrick Gendron

              Hi Jop,

               

              I tested your Scenarios.qvw and it works great but I have a question.

               

              It seems that the partial reload is not necessary.  I disabled the "ActiveDocument.PartialReload" from the last action Run Macro and it is still working.  Can you explain why do I need to do a partial reload at that time?

               

              --> Last action: Run Macro

               

              Sub ExportLocal()

               

                  set obj = ActiveDocument.GetSheetObject("CH01")

               

                  obj.ExportEx "Scenario.qvd", 4

               

                  ActiveDocument.GetApplication.WaitforIdle(1000)

               

                  'ActiveDocument.PartialReload

               

              End Sub

               

              Thanks,

               

              Patrick