topic What-If Analysis in QlikView

What-If Analysis

Thu, 15 Jan 2015 06:52:45 GMT

Hi all,

While doing what if analysis, how to take two fields into consideration. For example see below image. I need to take Energy loss in my expression . At present calculated energy loss is 18.4% that means my pointer should be nearer to 20, when what if Energy sales is 10111155 . can any one help.

My exp : Sum ( distinct TOTAL_ENERGY_SALES )*(1-vEnergyLoss/100)

Re: What-If Analysis

Anonymous — Thu, 15 Jan 2015 07:11:00 GMT

Janaki

can you explain what exactly you want . Your problem is not clear .

If possible attache sample data and sample QVW and expected result .

Re: What-If Analysis

Thu, 15 Jan 2015 07:18:11 GMT

Hi Chandel,

Nice to see you again, Take that image as ref ,in that image What if Energy Sales field should reflect with Energy Loss .At the moment it is not happening.The exp I used for what if Energy sales is .

Sum ( distinct TOTAL_ENERGY_SALES )*(1-vEnergyLoss/100)

Re: What-If Analysis

Thu, 15 Jan 2015 13:08:03 GMT

Hi Chendel , Sorry for the late reply, PFA

My requirement is to show energy loss changes by what if analysis. can you help me on this @chendel