topic Legends in Line chart. in QlikView

Legends in Line chart.

Wed, 05 Jan 2011 15:09:04 GMT

I had like to get the legends in the following manner.

I can only concatenate and display the legends. Is there any other way other than to concatenate dimensions?

-Naveen

Legends in Line chart.

Oleg_Troyansky — Wed, 05 Jan 2011 17:02:23 GMT

I suppose you are referring to Dimension Labels, not the Legend...

I don't think you can do it in the boundaries of a single chart.

If it's extremely important to get this presentation, I'd try overlaying 2 different charts on top of each other - one with the Week as a Dimension, and another one with the Month as a dimension, and hiding the values and the plot for the Monthly chart. It requires a lot of alignment between the two charts, and you'll have to arrange an alternative way of printing or exporting an image, since the regular chart image won't include Month Labels.

Another possible solution would be to add "Text in Chart" and fit Month Names as a text - might be a bit tricky, though...

Legends in Line chart.

johnw — Thu, 06 Jan 2011 01:44:28 GMT

This probably doesn't address your main concern, as the underlying solution is still just concatenation. But it uses a calculated dimension that only displays the year on the first month for that year that is in the chart. That at least makes it LOOK a little more like there are two dimensions.

I don't know why QlikView doesn't support multiple X-axis dimensions. It seems so basic.

Legends in Line chart.

johnw — Thu, 06 Jan 2011 02:00:02 GMT

Well, you can't do it with a line chart, but you could also make a pivot table with your two dimensions and use a linear gauge for each combination to create a vertical bar chart. You probably wanted lines and probably don't want it vertical, but I thought I'd throw that out there too.

Legends in Line chart.

Thu, 06 Jan 2011 05:47:55 GMT

Thanks John..

Thanks Oleg..

Let me get this discussion posted on how I am concluding it..