Discussion Board for collaboration on QlikView Layout & Visualizations.
I would like create what if analysis , like select a buyer increase or decrease its projections. Please kindly refer the below and advise
E.g Buyer A increase its projection by 250
Buyer c decrease its projection by 50
have you tried input fields?
There are objects like Sliders that are really useful for these analysis, right click -> new sheet object -> sliders / calendar
Create two variables that can be manipulated with a slider.
In a pivot table create an expression something like this:
If(Buyer='A', Projection*VariableforBuyerA, if(Buyer='B', Projection*VariableforBuyerB))