Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

"What if" Fields

Is it possible to put in "What if" Fields in a pivot table? If yes, how can I do that.

1 Reply
Miguel_Angel_Baeyens

Hello,

If you mean you can compare actual data in your charts with some other you can allow the user to change, I would create a variable in the script (or as many as you need) and a slider object for those variables. Then, include in the charts expressions for calculations with those variables. Say you want to know what if sales amount is increased in certain percentage. The slider will allo the user to select that percentage, storing the selected value into a variable. Then, your chart will have an expressions like the sales mount you actually have, but multiplied by the variable.

Any time the slider changes, the chart will change as well.

Anyway, not know anything else about what do you want to accomplish, is very difficult to give a more accurate answer.

Regards.