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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

what if analysis

Hi

what is "what if analysis"?give the suitable example for that?

5 Replies
Not applicable

Hi prabhas ,

go through below link hope it will help,

What If analysis.doc

What If Analysis in Qlikview.docx

sagarkharpude
Creator III
Creator III

PFA

Not applicable

Hi Prabhas

Check the Attachment also.

In a nutshell, a 'what if' analysis looks at historical, predicted or budget data and then adjusts this actual data by one or more factors to show a 'what if' value.

At it's most simple it may be adding a percentage shift (say +10%) to last years figures to predict the next years.  This in itself does not reveal much.  You could look at a composite shift, so say you expect sales to go up by 10% but costs to rise by 15% with margins being shrunk by prices only rising by 5% - when all that is layered on top of your existing data what does the picture look like?

I have done analysis where the user requested that they could apply a different offset to each of the territories in their data - again the composite picture of those different adjustments could be seen.

Often these offsets are set using variables and QlikView slider objects.  These however take up a lot of space on the screen - so sometimes a simple input box with numeric constraints on is a better approach.

Hope this gives you some pointers.

Regards

Naveen.

Not applicable

Hi Prabhas

here is the Example for 'What if'

jpenuliar
Partner - Specialist III
Partner - Specialist III

below thread with other examples:

Qlikview how to:

http://community.qlik.com/docs/DOC-5486