topic Re: Qlik Above function in Bar chart not working in QlikView

Qlik Above function in Bar chart not working

mkb_Qlik — Sat, 16 Nov 2024 18:16:31 GMT

Hi,

I have a table like below,

Each period holds YTD values (except 201901 & 202001). i wish to find out monthly figures for each period.

The same has been successfully found by using below expression .

IF((LEFT(Period,4) <> Above(LEFT(Period,4))),(SUM({<TYPE={'REEL'}>}YTD_Value)),
(SUM({<TYPE={'REEL'}>}YTD_Value)- Above(SUM({<TYPE={'REEL'}>}YTD_Value))))

Now all i need is adding additional country dimension to show same in BAR Chart.

But when i reuse the same expression its not showing monthly value instead it shows YTD Value If i not consider period column.

Any suggestion how to fix this in Bar chart to show cumulative sum in bar chart country wise.

Re: Qlik Above function in Bar chart not working

sunny_talwar — Tue, 04 Aug 2020 19:15:46 GMT

Try this

Aggr( If(Left(Period, 4) <> Above(Left(Period, 4)), Sum({<TYPE = {'REEL'}>} YTD_Value), Sum({<TYPE = {'REEL'}>} YTD_Value) - Above(Sum({<TYPE = {'REEL'}>} YTD_Value)) ) , COUNTRY_CODE, (Period, (NUMERIC)))

Re: Qlik Above function in Bar chart not working

mkb_Qlik — Wed, 05 Aug 2020 03:45:43 GMT

Hi @sunny_talwar ,

Thanks for your assistance.

However given expression works well when i consider period dimension in Bar Chart. Any other suggestions to show the aggregation at Country Code level.

Thanks in advance!

Re: Qlik Above function in Bar chart not working

sunny_talwar — Wed, 05 Aug 2020 10:58:34 GMT

Try this may be

Sum(Aggr( If(Left(Period, 4) <> Above(Left(Period, 4)), Sum({<TYPE = {'REEL'}>} YTD_Value), Sum({<TYPE = {'REEL'}>} YTD_Value) - Above(Sum({<TYPE = {'REEL'}>} YTD_Value)) ) , COUNTRY_CODE, (Period, (NUMERIC))))

Re: Qlik Above function in Bar chart not working

mkb_Qlik — Wed, 05 Aug 2020 11:04:21 GMT

Hi @sunny_talwar

Thank you very much for your assistance.

I have fixed this case from back end scripting.

Thank You!

Re: Qlik Above function in Bar chart not working

sunny_talwar — Wed, 05 Aug 2020 11:25:19 GMT

Awesome