topic Re: Current Value Passing By Variable in QlikView

Current Value Passing By Variable

Fri, 16 Jan 2015 09:59:37 GMT

Hi all,

I have below mentioned requirement .

While doing what if analysis I need to show present energy loss by Slider object, On attached QVW it is not happening.

Is there any possibility to do that.

Thanks,

Re: Current Value Passing By Variable

Gysbert_Wassenaar — Fri, 16 Jan 2015 10:15:48 GMT

I have no idea what you're actually asking. See attached qvw for a guess to an answer.

Re: Current Value Passing By Variable

Fri, 16 Jan 2015 10:39:30 GMT

Hi Gybert,

Whenever user opens the sheet slider should show the present energy loss %,For example by given in-line data the total energy loss is 23%, here slider should show 23% first. Is it possible.

Thanks,

Re: Current Value Passing By Variable

Gysbert_Wassenaar — Fri, 16 Jan 2015 10:48:23 GMT

23% ? How do you get that number?

Total energy sales is 7461514

Total energy consumed is 7141734

Total energy loss is 319780

So where does the 23% come from?

Re: Current Value Passing By Variable

Fri, 16 Jan 2015 11:08:23 GMT

Sorry that was a mistake...it is not 23% . correct one is 4.28%, it is energy loss % form energy sales.

Re: Current Value Passing By Variable

Gysbert_Wassenaar — Fri, 16 Jan 2015 11:15:40 GMT

Calculate the value in the script:

T1:
LOAD * INLINE [
    Category, Energy Sales, Energy Loss, Energy Consumed
    L1, 1393567, 70027, 1323540
    L2, 4962453, 48142, 4914311
    L3, 1105494, 201611, 903883
];

T2:
LOAD sum([Energy Loss])/sum([Energy Consumed]) as [Perc Energy Loss]
Resident T1;

LET vEnergyLoss = round(peek('Perc Energy Loss')*100,0.1);

DROP TABLE T2;

Re: Current Value Passing By Variable

Fri, 16 Jan 2015 12:12:17 GMT

Hi Gysbert,

I am almost there, I got the slide bar result right. But as below mentioned image those two column values should be identical before doing the slide bar selection. PFA QVW.. !

Re: Current Value Passing By Variable

Gysbert_Wassenaar — Fri, 16 Jan 2015 12:59:31 GMT

That is impossible. The What-if expression uses the variable and you want the variable to have the initial value of the loss percentage. You cannot have it both ways. Or the variable is zero and the What-if values are as you require or the variable is initialized like you want and the what-if values are calculated accordingly.