Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
Not applicable

what if analysis?

I want to create a what if analysis to find budget variance

eg:

Projection

Load %

I have Projection and I want with in those projection if I Load some amount of % what will happened to budget and if budget is lose

or - figure what is the % of quantity I have to Load. can any one help me on above scenario? Thanks in advance!!

MonthsbudgetProjectionLoaded
JAN1000090009020
FEB500004500044500
MAR200002000019000
APR200002000020000
MAY400003950029500
JUN300002850018500
JUL1000097509720
AUG500005000049000
SEP300003000030000

lets say I got a table as above and I want to know when the Projection is some value or qty when I increase or decrease Loaded in % I want to know what will happened to Budget is it a lost or profit also if it is a lost how much more I have to load every next month to achieve what was projected

Tags (1)
1 Solution

Accepted Solutions
lucianosv
Valued Contributor

Re: what if analysis?

Good morning.

See this app. It may help you. It's similar your need.

5 Replies
lucianosv
Valued Contributor

Re: what if analysis?

Good morning.

Can you post a print with the table you expect? Do you need to project the differences to the next months?

Not applicable

Re: what if analysis?

yeah excatly, what i have mention before is the table

hannan_t
New Contributor III

Re: Re: what if analysis?

Hi,

Yes you can achieve this by using slider object. It is very simple process. Kindly view the attached document for the detailed implementation.

Regards,

Hannan Tariq

lucianosv
Valued Contributor

Re: what if analysis?

Good morning.

See this app. It may help you. It's similar your need.

Not applicable

Re: what if analysis?

Thank You!