Use Rangesum to make Stacked bar chart with categores

[nihar1411]

Hi,

I am trying to create a stacked bar chart such that it shows the cummulative sum.

I can easily do this in EXCEL by making  a pivot, and the adding a Running Total In column to make a bar chart.

Hoever i am struggling since 6 hrs to find a fix in qlik.. I am using the formula rangesum(above(TOTAL Sum( Count),0,RowNo(total))). I can make a bar chart with total count, however when i add the categories, the graphs gives way. 

I am attaching the excel with test data

Thanks in Advance!

[msKarthikeyan]

Hi Nihar,

Try this.

Aggr(Rangesum( Above(Sum(Count), 0, RowNo())), Category,DATE_BUCKETS)

-Karthik 

[nihar1411]

Thanks Karthik..

This helps and works 🙂