topic Re: Dynamic Expression Labels in QlikView

Dynamic Expression Labels

Anonymous — Fri, 16 May 2014 11:20:24 GMT

As shown in image, I have a requirement that I want label of expression change on basis of dimension(Year Month).

If Year month is greater than that of today the value should be different.

Kindly help....

Regards

Nitin

Anonymous — Mon, 19 May 2014 08:38:20 GMT

Can Anyone Help please..........

Mon, 19 May 2014 08:41:26 GMT

what kind of chart are you using?? in a pivot table you could wite:

if(Month <= Month(Today()),'Sales Previouse','Forecast')

hope this helps!

regards,

Anonymous — Mon, 19 May 2014 08:46:21 GMT

I have used the same expression, but its not working.

I think labels works as text boxes so according to dimensions they do not vary

Mon, 19 May 2014 08:48:48 GMT

sorry let ma correct my answer you need to write:

=if(Month <= Month(Today()),'Sales Previouse','Forecast')

regards,

tresB — Mon, 19 May 2014 08:51:01 GMT

Your understanding is correct. Label doesn't recognize dimension values. Therefore you won't get different labels for any dimension.

Anonymous — Mon, 19 May 2014 08:52:09 GMT

Whats the difference in both of above...

They are same ...

Anonymous — Mon, 19 May 2014 08:53:00 GMT

Hi Tresesco,

I there any other way around to fullfill the requirement.

Mon, 19 May 2014 08:54:26 GMT

no one has an equal-sigh (=)

jagan — Mon, 19 May 2014 08:55:01 GMT

Hi Nitin,

Please find attached file. Label doesn't recognize dimension values, so it is not possible, create a calculated dimension like in attached file.

Regards,

Jagan.