topic Re: Multiple aggregations in straight charts in QlikView

Multiple aggregations in straight charts

kdmarkee — Sat, 16 Nov 2024 00:40:59 GMT

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.

Re: Multiple aggregations in straight charts

Or — Wed, 13 May 2020 18:27:52 GMT

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.

Re: Multiple aggregations in straight charts

kdmarkee — Mon, 18 May 2020 17:03:27 GMT

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.