Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Multiple aggregations in straight charts

I'm wondering if it is possible to do multiple levels of aggregations in a straight chart.   I can probably achieve this via script but am looking for confirmation if that is my only option.  See below.  The gray chart is the first level of aggregation, and the yellow chart is what I ultimately need to show.  Thanks.

2 layers of roll up.PNG

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Thank you for your feedback, I appreciate it.  For now I did build what I needed in the script, but might try your suggestion out of curiosity.

View solution in original post

2 Replies
Highlighted
Specialist III
Specialist III

I'm not sure what your limitations are, but this looks like it would be achieved using:

Aggr(Sum([Actual Hours])/Sum(Available Hours),Facility,Year)

 

If you're trying to put this in the same columns of the original table, though, you'd have to somehow generate the extra rows first (let's call them RowType = Summary), and then presumably use something like:

If(RowType = 'Summary',Aggr(Sum([Actual Hours])/Sum(Available Hours),Facility,Year),Sum([Actual Hours])/Sum(Available Hours))

Not sure if there's any good way to achieve these extra rows at the chart level - if I had to do this, I'd put them in the script.

Highlighted
Specialist
Specialist

Thank you for your feedback, I appreciate it.  For now I did build what I needed in the script, but might try your suggestion out of curiosity.

View solution in original post