topic label expression based on dimension in QlikView

label expression based on dimension

amien — Mon, 12 Apr 2010 09:56:45 GMT

how can i set the label of an expression.. based on the value of above dimension (i'm using a pivot)

Thanks!

label expression based on dimension

amien — Mon, 12 Apr 2010 12:21:27 GMT

or if i have something like columnno in the pivot then i can this in label with IF's

columnno is not working btw 🙂

label expression based on dimension

d_pranskus — Mon, 12 Apr 2010 13:41:34 GMT

Actually I believe that value of the label cannot be based on dimension value, because it is calculated before the chart is being rendered.

Nevertheless here is some workaround.

Cheers

Darius

label expression based on dimension

amien — Fri, 27 Jan 2012 23:48:47 GMT

Ok, sorry for the late reply .:)

but i don't get it .. i know PICK, but you use that in your expression. i have one fixed expression SUM(value) and i need a different label for each one .. do i need to use PICK in the Label Expression?

label expression based on dimension

CELAMBARASAN — Sat, 28 Jan 2012 04:48:35 GMT

Hi,

Can you tell me based on what condition the dimension gets changed?.

Celambarasan

label expression based on dimension

amien — Sat, 28 Jan 2012 22:25:00 GMT

my pivot has:

2 dimensions: 1 on the left and 1 on top

3 expressions: the label name of the last expression should be dynamic

the name is based on the second dimension (the one that is on top).

so, it can be dimension name. Or perhaps on the position of expression 3 : the first two columns needs to be a certain name, and de rest another name.