Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

variable in text box

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

5 Replies
ali_hijazi
Honored Contributor

Re: variable in text box

what is the definition of $(variable)?

Not applicable

Re: variable in text box

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'

     )

)

MVP
MVP

Re: variable in text box

PFA

sasikanth
Valued Contributor III

Re: variable in text box

hi

in Text box write like

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

make sure that it shoud be a single value

Not applicable

Re: variable in text box

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

Community Browser