topic Re: Question about using Aggr with Combo chart in QlikView

Question about using Aggr with Combo chart

datagrrl — Fri, 15 Nov 2024 23:47:34 GMT

I am trying to create this combo chart. For the symbols I would like them to line up with the correct year.

I am using an aggr expression for the symbol.

aggr({<[Case Owner] = {"=Rank(sum(%CaseId))<=50"}>}count(%CaseId),Year,Priority)

Re: Question about using Aggr with Combo chart

Kushal_Chawda — Fri, 16 Oct 2020 21:54:41 GMT

@datagrrl what is the expected output with number?

Re: Question about using Aggr with Combo chart

Brett_Bleess — Tue, 27 Oct 2020 19:52:11 GMT

Only thing I have to add is the following Design Blog that might help a little:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

I am with Kush though, not exactly sure to what you are referring, so maybe pointing out exactly the piece you need help with via some arrows or something would help, as I am not quite sure myself.

Regards,
Brett

Re: Question about using Aggr with Combo chart

datagrrl — Thu, 12 Nov 2020 18:28:40 GMT

I think the problem goes back to you can't have two dimensions and two measures in a combo chart.

Re: Question about using Aggr with Combo chart

edwin — Thu, 12 Nov 2020 19:06:43 GMT

You can have multiple dimensions and multiple measures. attached is a view of your chart with years stacked instead

but for your specific case, you need to be clear what you want. also, you do have a year that is null - this is due to the synthetic keys in you data model.

Re: Question about using Aggr with Combo chart

datagrrl — Thu, 12 Nov 2020 20:04:22 GMT

This is data from a sample document. I can clean it up, but I don't think that will change what I am asking for.

I remember this being something I could not do in the past. I don't think a stacked chart would work in this situation. I don't think it visualizes this well.

I want the symbols to line up with the correct year, not all in the center.

Re: Question about using Aggr with Combo chart

datagrrl — Thu, 12 Nov 2020 19:51:14 GMT

I want the symbols on the correct year. Currently all of them end up on the middle year.

Re: Question about using Aggr with Combo chart

edwin — Thu, 12 Nov 2020 23:37:35 GMT

I didnt think that was possible bec the grouping is a visualization of the BARs not really a data point for the line chart. your line chart can only have one dimension - the first dimension. however, if you combine both dimensions then you will have all the data points (dimension wise) that you need: