Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

what if analysis

Hi All

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

COMPANYQUARTERBUYERActualConfirmedProjection20142013Variance with Last YearBudgetVariance with Budget
EMJAYQtr1A10001002001505080120
EMJAYQtr1B000050-5070-70
EMJAYQtr1C10001002005015090110

Thank You

BR

Jayanthan

3 Replies
Highlighted
Partner
Partner

have you tried input fields?

Highlighted

There are objects like Sliders that are really useful for these analysis, right click -> new sheet object -> sliders / calendar

Highlighted
Creator II
Creator II

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

Br

Cris