Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

condition in the help field

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

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

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

regards-bika

View solution in original post

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

  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

Not applicable
Author

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

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

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

regards-bika

Not applicable
Author

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?

Not applicable
Author

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.

Not applicable
Author

Yes dear..it will work