topic Re: RangeSum not working as intended in BAR chart. in QlikView

RangeSum not working as intended in BAR chart.

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

Hello,

I am fairly new to Qlikview. I have a bar graph with two dimensions (Demand Type and YYYYQ) and one measure on which I am doing a rangesum.

RANGESUM(BELOW(SUM({$<Datatype={'MPDemandsCRSD'}>}BACKLOG_UNIT_QTY),0,RowNo()))

But the rangesum is not working as intended, can you tell me what is missing? As you can see the green portion of the bar should stack up all the way till the last quarter shown (20191) and so is the case with the blue portion of the bar (backlog). It works perfectly in a pivot table.

Thanks in advance.

Re: RangeSum not working as intended in BAR chart.

sunny_talwar — Fri, 09 Mar 2018 20:06:12 GMT

Try this

Aggr(RangeSum(Above(Sum({$<Datatype={'MPDemandsCRSD'}>}BACKLOG_UNIT_QTY), 0, RowNo())), DEMAND_TYPE, YYYYQ)

Re: RangeSum not working as intended in BAR chart.

Anonymous — Fri, 09 Mar 2018 20:11:22 GMT

Thanks for the quick response and I did try this before I posted and sadly it does not work.

Re: RangeSum not working as intended in BAR chart.

sunny_talwar — Fri, 09 Mar 2018 20:12:56 GMT

It might help to know what makes you think it is not working.... numbers are wrong... you see nothing (blank chart).... computer shuts down ....

Re: RangeSum not working as intended in BAR chart.

Anonymous — Fri, 09 Mar 2018 20:19:04 GMT

The numbers are wrong and the accumulation is not happening by the demand type.

Re: RangeSum not working as intended in BAR chart.

sunny_talwar — Fri, 09 Mar 2018 20:20:30 GMT

How about this

Aggr(RangeSum(Above(Sum({$<Datatype={'MPDemandsCRSD'}>}BACKLOG_UNIT_QTY) + Sum({1} 0), 0, RowNo())), DEMAND_TYPE, YYYYQ)

Re: RangeSum not working as intended in BAR chart.

Anonymous — Fri, 09 Mar 2018 20:35:26 GMT

Thanks for your quick response Sunny but this had a syntax error and would not work.

The error was here right after the RowNo()))

Aggr(RANGESUM(Above(SUM({$<Datatype={'MPDemandsCRSD'}>}BACKLOG_UNIT_QTY),+Sum({1}0),0,RowNo())) ,DEMAND_TYPE,YYYYQ)/$(vMetricsSelector)

Re: RangeSum not working as intended in BAR chart.

sunny_talwar — Fri, 09 Mar 2018 20:37:30 GMT

Did you accidentally add a comma here?

Re: RangeSum not working as intended in BAR chart.

Anonymous — Fri, 09 Mar 2018 20:48:31 GMT

I fixed the typo and this is what I see. The first quarter always is correct and it matches the same pivot table below. Also interestingly if i did a fast change on this bar graph to pivot the values are correct. Only the chart is way off.

Here is the pivot on the fast change for the same graph:

Re: RangeSum not working as intended in BAR chart.

Digvijay_Singh — Fri, 09 Mar 2018 21:08:49 GMT

Works this way with the sample attached -