conditional expression

lahpro — Mon, 01 Apr 2019 08:44:50 GMT

Hi all,

I have a straight table with multiple expressions from which each should be visible as soon as the users selects a certain field from a search object / list box. The user may take multiple selections to show multiple expressions in one chart.

To achieve this I use the following condition: index(GetFieldSelections(Dimension),'Fieldname') > 0

However, if the user clicks a fieldname that includes a word that is simultaneously the fieldname of another expression both expressions get visible although one fieldname has been selected.

Example:

User's field selection: sales after cancellation

Expression 1 has the condition: index(GetFieldSelections(Dimension),'sales') > 0

Expression 2 has the condition: index(GetFieldSelections(Dimension),'sales after cancellation') > 0

Both expressions are visible.

Expected outcome: Only expression 2 should be visible.

Renaming of fieldnames is no option. Do you have any idea how to solve this problem?

Re: conditional expression

tresB — Mon, 01 Apr 2019 09:06:01 GMT

To avoid such issues, you could use special characters in concatenation like:

 index('@'&GetFieldSelections(Dimension, '@')&'@','@sales@')

 index('@'&GetFieldSelections(Dimension, '@')&'@','@sales after cancellation@')

topic Re: conditional expression in QlikView

conditional expression

Re: conditional expression