Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional and trigger to select multiple fields

Hi All,

the problem seems to be easy to solved but...

Im trying to set up the trigger on field "Przekroje" --> Select in second field - MiaryID

in search string when im wrote " =if(PrzekrojeID=1,'2') " all works fine.

But when im trying to write =if(PrzekrojeID=1,(2|3)) this is not working...

How can i write in this trigger 2 fields ? 2 and 3 to select ?

Thank you in advance for your answer!

Jacek Antek

6 Replies
sunny_talwar

Have you tried it with single quotes or double quotes?

=If(PrzekrojeID=1, ('2'|'3')) or

=If(PrzekrojeID=1, ("2"|"3"))

shair_abbas
Partner - Creator
Partner - Creator

Use Toggle select it will add selection in Specific filed.

Anonymous
Not applicable
Author

Yes i have tried this and this is not working

settu_periasamy
Master III
Master III

your expression seems to be fine. (if there is no space, it will work)

May be try with double Quotes.. Like

=if(PrzekrojeID=1,'('&chr(34)&'1'&chr(34)&'|'&'2'&chr(34)&')')

Anonymous
Not applicable
Author

Trigger for multiple fields within conditional doesn't work (there is no space).

Toggle select did my job

Thank You All!

sunny_talwar

Would you be able to share a sample?