Discussion Board for collaboration on QlikView Layout & Visualizations.
I have two objects - a pivot table and a slider.
A slider contains a variable. Changes in slider/variable should not affect the pivot table.Is it possible to do that? If yes, how? Maybe with some kind of set analysis restrictions?
Go to Solution.
Deleting everything in the set condition except "Digital_Sale_IND" worked.
Thanks for your support.
Have a look at Develop a what-if analysis with QlikView.
What kind of analysis are you doing?
Can you post some sample data and qvw file to analyze further.
In our expression if we want to change the value based on slider, then we can use teh slider variable in th expression.
If not slider value will not reflect in the pivot table.
Can you post sample application.
Thanks for your reply.
The app is almost 400 MB big. Therefore, I cannot send it.
However the question is conceptual - is it possible make that changes in slider do not affect the pivot table?
I don't know why you are using slider.
have a look at attached post.
Preparing examples for Upload - Reduction and Data Scrambling
Find the attached application.
May help you out
Thx for the reply.
This is what I tried. Here is how the expression in the pivot table looks like:
$(vHD_MonateBackOffset) = 1
The variable vHD_MonateBackOffset is the variable contained in the slider.
However, when I change the variable in the slider, the changes are still reflected in pivot table, although I have set the vHD_MonateBackOffset = 1.
Why does it not work?