topic Re: Conditional and trigger to select multiple fields in QlikView

Conditional and trigger to select multiple fields

Anonymous — Mon, 01 Feb 2016 11:50:49 GMT

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

sunny_talwar — Mon, 01 Feb 2016 12:27:17 GMT

Have you tried it with single quotes or double quotes?

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

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

shair_abbas — Mon, 01 Feb 2016 12:28:11 GMT

Use Toggle select it will add selection in Specific filed.

Anonymous — Mon, 01 Feb 2016 12:30:31 GMT

Yes i have tried this and this is not working

settu_periasamy — Mon, 01 Feb 2016 12:37:22 GMT

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 — Mon, 01 Feb 2016 13:03:36 GMT

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