Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikSense does NOT recalculate data/refresh view

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.

2 Replies
dwforest
Specialist II
Specialist II

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....

miguel_m_cunha
Partner - Contributor II
Partner - Contributor II

Hello guys,

 

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

 

Thanks in advance!