Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.)
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.
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....
Hello guys,
I'm Having exactly the same problem. Have you found any way to solve this problem?
Thanks in advance!