topic Re: Expression as legend in Line Chart in QlikView

Expression as legend in Line Chart

pradnyat — Thu, 15 Jan 2015 11:07:03 GMT

Hi All,

We are using one line chart to show 2 Expressions: Market Share and Benchmark Market Share.

We have activated 'Expression as legend' from Expression tab.

This Expression legends are coming fine when we have some value for both the expressions, But in case where we don't have market share but we are getting Benchmark Market Share , there expression legends are not coming.

Is there any solution for this.

Thanks in Advance... !

Re: Expression as legend in Line Chart

alexandros17 — Thu, 15 Jan 2015 11:13:21 GMT

unfortunately no, automatic legend comes out only with more that an expression

hope it hlelps

Re: Expression as legend in Line Chart

vinay_hg — Thu, 15 Jan 2015 11:24:28 GMT

try to write the same expressio n for lagends in lagend option

Re: Expression as legend in Line Chart

Anonymous — Thu, 15 Jan 2015 11:27:33 GMT

Pradnya

I guess that your Expression legend disappears when all values to be displayed are null.

If so then try something like this for your expression to flip nulls [& anything else not a valid number] to zero :

=alt ( [MarketShare] ,0 )

Re: Expression as legend in Line Chart

datanibbler — Thu, 15 Jan 2015 11:30:01 GMT

Hi,

by default, expressions - and the corresp. figures in the legend - will only be displayed if there is anything to be displayed.

So you have two options: Either you somehow fill the rows in the table (in the script) where that value should be with a 0 in case there is no value, so QlikView always has something to show - or you deactivate that checkbox and create some free_text_boxes instead.

Re: Expression as legend in Line Chart

Clever_Anjos — Thu, 15 Jan 2015 11:35:48 GMT

Easier solution is putting some textboxes as legend

Re: Expression as legend in Line Chart

reshmakala — Thu, 15 Jan 2015 14:58:02 GMT

If you want to put some legends manually as text, there is an option with the properties.

Go to the chart properties -> Presentation tab..At the bottom right, you have text in chart. Add the text that you wanted to add and set the angle as per how you need it to display in your chart.

When you get the text in the chart, Press and hold Ctrl+Shift and drag it to the place you wish to put it.

Hope that helps!