Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
laurentubesing
Contributor
Contributor

Cummulative Bar Chart - 2 Dimensions

Hi -  

I've been working for hours to create a cumulative bar chart that has 2 dimensions and coming up flat.

Dimensions:

Month

Root Cause

Measure:

Case Number

 

I've read and read and read on this and can't get it to work.  I'd like to see the culmination of the case number of each root cause category by month.

My Root Cause are the carious lines (i have about 4) and i'd like them to be culminated by month (if that helps).

here's my current equation

Aggr(RangeSum(Above(Count([Case Number]),0,RowNo())),[Root Cause], [Action Closure Date.autoCalendar.Month])

 

please help!

Lauren

3 Replies
JordyWegman
Partner
Partner

Hi Lauren,

Try this:

RangeSum(Above(Count([Case Number]),0,RowNo()))

You don't need the aggr for this.

If you want more lines, use set analysis in the Count([Case Number]) to get multiple lines.

Jordy

Climber 

Work smarter, not harder
laurentubesing
Contributor
Contributor
Author

Thank you! That's much closer  than where I was.  It looks like it's culminating up til May ... then it drops off.  Any ideas?

qs.JPG

 

JordyWegman
Partner
Partner

Good, but this looks a bit strange indeed. Do you have some sample data to test with?

Jordy

Climber

Work smarter, not harder