Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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