Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Nihar,
Try this.
Aggr(Rangesum( Above(Sum(Count), 0, RowNo())), Category,DATE_BUCKETS)
-Karthik
Thanks Karthik..
This helps and works 🙂