topic Re: What if Analysis in QlikView

What if Analysis

bhaskarsharma03 — Wed, 20 Feb 2013 09:37:19 GMT

Hi,

I want to do a What-If Analysis. I have a Bar chart that shows the Sold Volume. Along with the Bar, I want to put another Bar that will be Sum of Sold Volume + Pipeline deals volume.

In the attached file, you will see a listbox that gives my Top 5 deals in pipeline. Below the listbox there's a chart with 2 Bars. The first Bar is my Sold Volume. The Second Bar is a what-if Sold Volume, which is the sum of Current Sold Volume and whatever pipeline deal I select from the Listbox above.

I want to see what will my Sold Volume look if any of the selected deals could be sold.

Please let me know if you need more information. Any help will be greately appreciated.

Re: What if Analysis

khadeer — Wed, 20 Feb 2013 11:58:06 GMT

Hi,

I hope these links and documents helps you. PFA.

http://www.quickqlearqool.nl/?p=625

Re: What if Analysis

bhaskarsharma03 — Wed, 20 Feb 2013 12:29:58 GMT

Thanks Khadeer.

My problem is little different. This cannot be done with sliders. You see there could be hundreds of deals lying in my pipeline, and I want to select some of them.

eg: I have displayed my Top 10 deals in pipeline in a listbox. Now I want to focus on say Deal numbers 2, 6 and 9. I just select them and they get added to my Chart which already has Sold Volume (check the image). This way i can compare my current Sold Volume, and my new Sold Volume if these 3 deals are sold.