topic Show legend when there is one dimension in Line chart in QlikView

Show legend when there is one dimension in Line chart

Sat, 06 Dec 2014 10:33:16 GMT

I have a line chart in which there is one dimension(Date) and two expressions(Endorsement/Production) conditionally, then how would I show Endorsement/Production as a legend in my chart.

Please help.

Thanks

Saurabh

Re: Show legend when there is one dimension in Line chart

Sat, 06 Dec 2014 16:20:00 GMT

HI Saurabh..

Normally you dont have an option to show the legend for such conditional expression however, there is an workaround...

you can use a dummy dimension.. but make sure you don't use any actual field as dimension.

like in your case create 2 calculated dimensions

='Endorsement' , using the enable condition for Dimension same as the enable condition of expression , and label as something you want as title of you legend ..

and

='Production' same as was done for first dummy dimension/

This should solve your case

Check out the attached Demo App

Re: Show legend when there is one dimension in Line chart

MarcoWedel — Sun, 07 Dec 2014 00:08:44 GMT

Hi,

I'm not quite sure about your requirements, but one solution could be:

Instead of switching expressions with a button/variable, you can also combine independent expressions into one synthetic dimension using the valuelist() function:

hope this helps

regards

Marco