1 Reply Latest reply: Jun 19, 2017 6:46 PM by David Forest RSS

    QlikSense does NOT recalculate data/refresh view

    Grzegorz Smajdor

      Hi,

       

      I have created a table which should be recalculated based on your choices (date, period type, quantity).

      The purpose is to show N previous periods (weeks/months/quarters) before selected date.

      It seems to be working properly, but.. it just seems.

      The problem is that your first choice is correct, but if you change for example - the date - Qlik Sense do NOT refresh the results.

      As you can see at the bottom of attached dashboard - values of variables are refreshed after each change, so it's very strange that Qlik Sense does not refresh the table's view.

       

      Please look at the scenario below and the attached file.

       

      Any ideas what is wrong? Why Qlik Sense does not display the data correctly?

       

      I use this extensions to change value of variables:

      http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

       

      Scenario:

      1. Type a date: 10/02/2012

      2. Select: months

      3. Choose 5 [how many]

      Periods seems to be calculated properly. (Sep-11 to Jan-12)

      4. Choose 6 [how many]

      Periods seems to be calculated properly. (Aug-11 to Jan-12)


      5. Change the date to: 10/01/2012

      6. Choose 10 [how many]

      Periods are displayed properly. (Mar-11 to Dec-11)


      7. Choose 5 [how many]

      Periods are displayed incorrectly.

      (Sep-11 to Jan-12, should be Aug-11 to Dec-11)

      (Sep-11 to Jan-12 is the previous table view - from point 3.)

      8. Choose 6 [how many]

       

      Periods are displayed incorrectly.

      (Aug-11 to Jan-12, should be Jul-11 to Dec-11)

      (Aug-11 to Jan-12 is the previous table view - from point 4.)


      As you can see it seems that QlikSense does NOT refresh/recalculate results.

      Also - QS stores results (the way of displaying this table) for previous choices.