topic Re: What is the –What If Analysis in QlikView... in QlikView

What is the –What If Analysis in QlikView...

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I am new to the QlikView, I am struggle to realize what is the - What if analysis in QlikView. Why peoples are calling what if analysis in QlikView?

Re: What is the –What If Analysis in QlikView...

Anonymous — Thu, 02 Jan 2014 17:45:14 GMT

Raja

When you install QlikView Desktop some examples are installed, see:

C:\Program Files\QlikView\Examples\Documents\Executive Dashboard.qvw

And look at the What If tab for an example.

Best Regards, Bill

Re: What is the –What If Analysis in QlikView...

Thu, 02 Jan 2014 17:56:09 GMT

Hi Bill,

Thanks for your quick response. If you have any document related this please share with me or please brief little bit elaborate.

Regards,

Raja.

Re: What is the –What If Analysis in QlikView...

Anonymous — Thu, 02 Jan 2014 18:01:36 GMT

Raja

I won't add any url's as they tend to get caught in the moderation quagmire.

But Google Wiki What if Analysis and you'll get loads of hits..

Best Regards, Bill

Re: What is the –What If Analysis in QlikView...

Anonymous — Thu, 02 Jan 2014 21:46:27 GMT

Usually when we want to show Top N analysis or Bottom N analysis, You might need the user to see the Top "X" numbers. For this we create a slider object using which the user can make his selections and the data shown in the charts will be filtered accordingly.

This is what is usually called what if analysis. Some times we also need to see like for example, what if the $ value is x.xx euros what will be the total revenue? Just an example.

Re: What is the –What If Analysis in QlikView...

stevedark — Thu, 02 Jan 2014 23:40:11 GMT

Hi Raja,

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,

Steve

Re: What is the –What If Analysis in QlikView...

ManikantaSirana549 — Thu, 14 Mar 2019 13:02:16 GMT

Hi Steve,

Can please provide any QVW/QVF , So that it helps me to be clear .

Regards

Mani