Solved: Pivot RangeSum() -> Line Chart Equivalent - Qlik Community

jsakalis · ‎2015-07-09

A colleague and I are a little stumped with creating a line chart equivalent of a pivot table (for one of the measures).

Attached is the pivot table and a line chart that approximates what we are looking for - if we can get each line to match the yellow % measure for each year, it would exactly what we are looking for.

We tried a number of different ways, unsuccessfully...

Any help with this really appreciated!

swuehl · ‎2015-07-14

Just take care in your production environment, that MOB field values have the correct load order, like you want to show in the line chart, numeric ascending. Advanced aggregation dimension values are always sorted by load order.

In your sample files attached, this was already the case.

View solution in original post

Report Inappropriate Content · ‎2015-07-10

This is an issue I have stumbled upon in the past and could never resolve...

I'm very interested in knowing the answer!!!!!!!!!!!

Help QlikView Masters!

jsakalis · ‎2015-07-13

Any brave souls out there with the magic needed?

Thanks in advance!

sunny_talwar · ‎2015-07-13

Will work on this when I get time today. Not sure if I will have a solution, but just wanted to let you know that I would love to give it a try

Best,

Sunny

jsakalis · ‎2015-07-13

Thank you so much! In the meantime, I will scratch my head a bit more.

sunny_talwar · ‎2015-07-14

I have the straight table to show the correct numbers, but as soon as I convert it into a Line chart the sorting changes and numbers go haywire. I know why it is doing it, but don't have a solution on this yet. The problem is simple, as soon as I convert it into a line chart, it sorts the expression by the first dimension and gives the result we are not looking for. If we can find a way to sort it by the second dimension in a line chart, the chart should work for you.

I am sharing my WIP with you, as may be collaboratively we can find the solution you are looking for.

PFA the qvw

HTH

Best,

Sunny

jsakalis · ‎2015-07-14

I tried it sixteen ways myself. This should really have a simple solution - just not obvious .

Thanks for your efforts!

sunny_talwar · ‎2015-07-14

May be its time to get the experts involved here. swuehl‌, MarcoWedel‌ can you guys help?

Best,

Sunny

swuehl · ‎2015-07-14

I think you probably want something like demonstrated in the attached two line charts

(first one has a filter on MOB between 0 and 24, like in the OP line chart, note that this will not replicated the pivot table column, second with filter removed, replicating the pivot table).

sunny_talwar · ‎2015-07-14

You are such a genius Stefan. One question though, why is the filtered chart starting with MOB = 2 and not 1? And also the percentages are not matching the one up top also?