Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nihar1411
Contributor II
Contributor II

Use Rangesum to make Stacked bar chart with categores

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!

 

 

end solution.png

Labels (3)
2 Replies
msKarthikeyan
Employee
Employee

Hi Nihar,

Try this.

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

 

bar chart.JPG

-Karthik 

nihar1411
Contributor II
Contributor II
Author

Thanks Karthik..

This helps and works 🙂