topic Re: variable in text box in QlikView

variable in text box

Fri, 13 Jun 2014 07:27:23 GMT

Hi all

i have a variable that contains an expression, the output of that expression is a character...

now i want to show the output of that variable in text box but i want to calculate it over a particular value of the time dimension..

it is right to calculate it like this ? = only({$<year = {'2014'}>} $(variable))

thanks, Loris

ali_hijazi — Fri, 13 Jun 2014 07:32:47 GMT

what is the definition of $(variable)?

Fri, 13 Jun 2014 08:05:39 GMT

if(($(mcc_rating_a)+$(mcc_rating_b)+$(mcc_rating_c)+$(mcc_rating_d)) >=9,

'A',

if(($(mcc_rating_a)+$(mcc_rating_b)+$(mcc_rating_c)+$(mcc_rating_d)) >=7,

'B',

'C'

)

tresB — Fri, 13 Jun 2014 08:13:17 GMT

PFA

sasikanth — Fri, 13 Jun 2014 08:13:33 GMT

in Text box write like

=if(year='2014' , $(variable))

make sure that it shoud be a single value

Mon, 16 Jun 2014 07:53:14 GMT

the expressionas i wrote it ( = only({ $<year = {'2014'}>} $(variable)) ) works...

my question is if it is a good way (through the only function) to achieve that result or if there is a better (more efficent) way...

or when i have to use the only function and when not