topic Re: How to use 3 dimensions in Line chart in QlikView

How to use 3 dimensions in Line chart

Fri, 09 Nov 2012 10:16:51 GMT

Hi All,

As far as I know Line chart has a limitation of showing only two dimensions, but is there any way to show 3rd dimension??

Re: How to use 3 dimensions in Line chart

jagan — Fri, 09 Nov 2012 10:20:40 GMT

HI Anil,

QV Reference manual says "Pie, line and scatter charts can display a maximum of two dimensions, bar, block and grid charts three". So try to use Bar or Block or Grid charts.

Regards,

Jagan.

Re: How to use 3 dimensions in Line chart

Gysbert_Wassenaar — Fri, 09 Nov 2012 11:58:22 GMT

There's also the trellis option to create a grid of line charts over a third dimension. Another option that sometimes works is creating a calculated dimension by concatenating two others. For example a calculated dimension SalesRep & '-' & Year together with Month as the other dimension and sum(Sales) as expression to create lines for each SalesRep+Year combination for the sales per month.

Re: How to use 3 dimensions in Line chart

Fri, 09 Nov 2012 13:05:05 GMT

Thnx for your replay Wassenaar, If possible could you please provide a sample file with trellis option.

Re: How to use 3 dimensions in Line chart

jagan — Fri, 09 Nov 2012 13:23:58 GMT

Hi,

Please check attached file for Trellis with 3 dimensions.

Regards,

Jagan.

Re: How to use 3 dimensions in Line chart

jagan — Fri, 09 Nov 2012 13:25:29 GMT

Hi Anil,

You can also try Grid chart for 3 dimensions.

Regards,

Jagan.

Re: How to use 3 dimensions in Line chart

Fri, 09 Nov 2012 14:00:17 GMT

Thanks for your replay Jagan, Concatenating and trills ooption both are fine if we have few values but i have nearly 25 values in two dimensions except time dimension we cant display all the values using trellis and concatenating will not work for my requirement.we have to implement this in line chart only.

Re: How to use 3 dimensions in Line chart

johnw — Fri, 09 Nov 2012 23:20:43 GMT

I'm unclear why concatenation won't work for your requirement. I mean, I understand it's not going to look very good when you have a whole lot of values. On the other hand, I don't see that ANY solution for just a line chart will look good when you have multiple dimensions with a lot of values. How exactly would you want the line chart to look?

Attached is an example of creating fake dimensions for a line chart by concatenation. Just to show two different approaches, the X axis is concatenated in the script, and the dimensions for the lines are concatenated in the chart. The main complexity in this example is trying to only display each of the "outside" dimensions once to help them look more like real dimensions. If not for that, the dimensions would be simple concatenations.

I do wish QlikView would just let us put in as many dimensions as we want, and tell it whether they should be on the X axis or not.

Re: How to use 3 dimensions in Line chart

marthacano01 — Tue, 27 Aug 2013 14:39:11 GMT

John, Thank you for helpful answer!!

Re: How to use 3 dimensions in Line chart

GraceGao — Thu, 07 May 2020 02:54:37 GMT

Hi Jonhw

i have same requirement for 3 dimension line chart as you posted. is that possible in Qlik Sense not Qlik view?

looking forward to your reply.

Thanks.

Re: How to use 3 dimensions in Line chart

Beginner_Qlik1 — Mon, 22 Apr 2024 11:46:50 GMT

HI John,

can 3 dimensions for the lines be concatenated in chart?