topic Re: Try to use line chart with two measures in QlikView

Try to use line chart with two measures

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can I have two dimensions and two measures on a line chart?

My target is

1) display the sales over the year per country = first measure

2) then draw a line that is the total of the sales worldwide. (with Rangesum) = second measure

--> All this on the same chart.

Thanks

Re: Try to use line chart with two measures

marcus_sommer — Sat, 10 Dec 2016 17:52:26 GMT

I don't think that it would be work like you expected it with one line-chart. A quite common alternative for such things is to use two or even more charts and to overlay them - by adjusting various layout-options to hide titles, axis and/or to make them transparent - beside some inbuilt options for this you could also use a function like argb(0,0,0,0).

- Marcus

Re: Try to use line chart with two measures

Sat, 10 Dec 2016 23:16:22 GMT

Ok, Thanks for the advice.

How can I overlay two charts? just drop them on each other doesn't work.

thanks

Re: Try to use line chart with two measures

MarcoWedel — Sat, 10 Dec 2016 23:31:16 GMT

Hi,

maybe one solution might be also:

(I guess there should be a shorter expression to solve this issue though)

hope this helps

regards

Marco

Re: Try to use line chart with two measures

swuehl — Sat, 10 Dec 2016 23:36:53 GMT

You would need to set the transparency to 100% for the top chart in colors tab of chart property.

I would like to suggest another approach:

Create a dimension that loads all your countries and add an additional value for 'World', which links to all Countries.

NewDimLinkTable:

LOAD Country,

Country as NewDim

FROM ...;

CONCATENATE

LOAD Country,

'World' as NewDim

FROM ...;

Now use NewDim as second dimension in your chart.