topic Re: condition in the help field in QlikView

condition in the help field

Tue, 23 Jul 2013 08:40:45 GMT

Hi there !

I would like to know if it's possible to etablish condition in the help field (the question mark in the legend). In fact, i would like to check if a value is selected in a field and display if it is.

Thank you for your help and sorry for the approximativ english.

Re: condition in the help field

kaushiknsolanki — Tue, 23 Jul 2013 08:43:33 GMT

Hi,

Yes you can write the if statements and any other conditional statements in Help Text.

Regards,

Kaushik Solanki

Re: condition in the help field

Tue, 23 Jul 2013 08:54:38 GMT

Currently my expresion is :

='TEXT' &num(MY_EXPRESSION)&' TEXT'

And I would to get an expresion as :

If nothing is selected in a specific field keep the above expression else ='TEXT' &name_of_record_in_the_specific_field &num(MY_EXPRESSION)&'TEXT'.

Could you help me to find an expression to do that?

Regards

Re: condition in the help field

Tue, 23 Jul 2013 09:11:14 GMT

=If(not IsNull(GetFieldSelections(specificfield)),

'TEXT' &name_of_record_in_the_specific_field &num(MY_EXPRESSION)&'TEXT',

'TEXT' &num(MY_EXPRESSION)&' TEXT')

regards-bika

Re: condition in the help field

Tue, 23 Jul 2013 09:22:33 GMT

Thank you bika, it works fine. Just one more thing I would like to get le &name_of_record_in_the_specific_field dynamically. Is it possible?

Re: condition in the help field

Tue, 23 Jul 2013 09:32:07 GMT

Ok I found. The final expresion is :

=If(not IsNull(GetFieldSelections(specificfield)),

'TEXT' &GetFieldSelections(specified) &num(MY_EXPRESSION)&'TEXT',

'TEXT' &num(MY_EXPRESSION)&' TEXT')

Thank you.

Re: condition in the help field

Tue, 23 Jul 2013 09:33:33 GMT

Yes dear..it will work