topic Re: Above function calculation in QlikView

Above function calculation

prma7799 — Fri, 22 Jul 2016 07:52:13 GMT

Hi All,

I have dimension as QurterYear and I am getting all qurteryear values in Bar graph but when am writing below code for Growth value then am not getting exact growth value for respected quarter.

=(( (SUM( [Sales Amount]) - SUM( [Return]) )

-above((SUM([Sales Amount])- SUM( [Return ])) ,4 )) /above((SUM( [Sales Amount]) - SUM( [Return])) ,4)) * 100

Thanks

Re: Above function calculation

MK_QSL — Fri, 22 Jul 2016 08:21:19 GMT

What is 4 here?

Re: Above function calculation

danansell42 — Fri, 22 Jul 2016 08:21:40 GMT

Are you trying to do a quarter on quarter growth?

I noticed you have put an offset of 4 and if its meant to be quarter on quarter then i would assume you should use 1 instead.

Also you might need to use the aggr function too.

Please try the below and hopefully this does what is required

=num((((SUM([Sales Amount]) - SUM([Return]) )-aggr(above((SUM([Sales Amount])- SUM([Return])) ,1,1 ),QuarterYear))

/aggr(above((SUM([Sales Amount])- SUM([Return])) ,1,1 ),QuarterYear)),'#,##0%')

Re: Above function calculation

danansell42 — Thu, 04 Aug 2016 10:40:43 GMT

Did this solve your query?

Please mark as correct to help other community users if it did.

Thanks

Dan

Re: Above function calculation

Anil_Babu_Samineni — Thu, 04 Aug 2016 10:47:34 GMT

=(( (SUM( [Sales Amount]) - SUM( [Return]) )

-above((SUM([Sales Amount])- SUM( [Return ])) ,4, 0 )) /above((SUM( [Sales Amount]) - SUM( [Return])) ,4, 0)) * 100