topic Re: what if analysis in QlikView

what if analysis

Tue, 14 Oct 2014 22:06:59 GMT

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

Thank You

Jayanthan

hectorgarcia — Wed, 15 Oct 2014 15:47:40 GMT

have you tried input fields?

alexandros17 — Wed, 15 Oct 2014 15:54:55 GMT

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

mr_novice — Wed, 15 Oct 2014 18:10:01 GMT

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

Cris