QlikSense does NOT recalculate data/refresh view

Anonymous — Fri, 16 Jun 2017 09:33:08 GMT

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.

Re: QlikSense does NOT recalculate data/refresh view

dwforest — Mon, 19 Jun 2017 22:46:52 GMT

it is because expressions are evaluated once upon chart rending, this is noted in the Help. You would need to do something besides change a variable value to get the chart to recalculate.

Maybe why the variable control is not standard....

Re: QlikSense does NOT recalculate data/refresh view

miguel_m_cunha — Thu, 29 Aug 2019 13:36:34 GMT

Hello guys,

I'm Having exactly the same problem. Have you found any way to solve this problem?

Thanks in advance!

topic Re: QlikSense does NOT recalculate data/refresh view in App Development

QlikSense does NOT recalculate data/refresh view

Re: QlikSense does NOT recalculate data/refresh view

Re: QlikSense does NOT recalculate data/refresh view