topic Re: Formula Calculation in QV Straight Table in QlikView

Formula Calculation in QV Straight Table

pradnya_amol — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Need help.

Attached here with is the mini data set of the file I'm working on (Sample Application). I have Month Number, Month Name, Actual Expenses column against which I need to calculate Run Rate in Front End on Straight Table but somehow I am not able to so I tried in Script and failed here as well.

Please take a look into it and help me solving it.

I will be grateful.

Thanks and Regards,

Pradnya.

johnw‌ !

Re: Formula Calculation in QV Straight Table

Anil_Babu_Samineni — Wed, 10 Oct 2018 11:23:51 GMT

Try this way?

If(Sum(Actuals)>0, Sum(Actuals),Above(TOTAL Sum(Actuals))/Above(TOTAL CalendarMonthNumber)*CalendarMonthNumber)

Re: Formula Calculation in QV Straight Table

shreya_nadkarni — Thu, 11 Oct 2018 02:11:05 GMT

Re: Formula Calculation in QV Straight Table

shreya_nadkarni — Thu, 11 Oct 2018 02:12:50 GMT

=if(Sum(Actuals)<=0,

above( total sum( Actuals ), 1 ) / above(total rowno,1) * max(rowno) ,

Sum(Actuals)

)

for 2nd :Column(2) instead of Sum(Actuals)

Re: Formula Calculation in QV Straight Table

pradnya_amol — Thu, 11 Oct 2018 04:31:50 GMT

Thanks Anil. The problem still persists as it taking only for Sept month and not for the other coming months. Can you please extend your help.

Re: Formula Calculation in QV Straight Table

shreya_nadkarni — Thu, 11 Oct 2018 06:05:57 GMT

=if(Sum(Actuals)<=0,

above( total sum( Actuals ), 1 ) / above(total rowno,1) * max(rowno) ,

Sum(Actuals)

)

for 2nd :Column(2) instead of Sum(Actuals)

Re: Formula Calculation in QV Straight Table

tresB — Thu, 11 Oct 2018 06:45:53 GMT

Try like below:

If(Actuals>0,Actuals, (Peek(NewRunRate)/(CalendarMonthNumber-1)*CalendarMonthNumber) ) as NewRunRate

Re: Formula Calculation in QV Straight Table

pradnya_amol — Thu, 11 Oct 2018 10:38:48 GMT

Yes Dear Thanks. I actually did the same but couldn't post and it worked.

Re: Formula Calculation in QV Straight Table

pradnya_amol — Thu, 11 Oct 2018 10:39:13 GMT

It worked when I changed the Column Name / Expression name

Re: Formula Calculation in QV Straight Table

pradnya_amol — Fri, 12 Oct 2018 04:34:22 GMT

Thanks a ton Shreya.