topic Re: Legends values in QlikView

Legends values

sibusiso90 — Thu, 09 Nov 2017 11:18:49 GMT

Hi All,

I am trying to get legend values in the correct place. I don't have any dimension they are all expressions.

Is this possible though.

E.G
I currently have the below

My result is below

Or — Thu, 09 Nov 2017 11:25:45 GMT

Select the chart, hold down CTRL+SHIFT, and drag the legend where you want it.

sibusiso90 — Thu, 09 Nov 2017 11:31:45 GMT

I don't want to move the legends I want them to appear as they would if I had a dimension

felipedl — Thu, 09 Nov 2017 11:37:50 GMT

Hi Sibusiso,

Do the following,

as for the dimension, use the following code:

=Valuelist('Sale','AVG','MAX')

and for expression do:

=pick

(

match

(

Valuelist('Sale','AVG','MAX'),

'Sale','AVG','MAX'

//Expression for sale

sum(Sales),

//Expression for AVG

avg(Sales),

// Expression for max

max(Sales)

)

As an example, i've loaded this:

load * Inline

[

Sales

];

And got the following with the mentioned expression and dimension:

Attached the file I used