Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I'd need a help with the use of event triggers and multiple values selection.
I have two goals:
The only solution I could find out is making a first "Select in Field" that searches all the values without spaces using the syntax "(Value1|Value2|...|ValueN)" to compose the "Search String", followed by a series of "Toggle Select" that looks singularly for the other values, except for those one I want to exclude.
If I try to use a "Select in Field" or "Toggle Select" with the cited syntax where one of the N value has a space, QilkView fails to apply the filter.
So my questions are:
Thanks a lot.
Any suggestion?
Hallo
I had the same problem a while, the problem is that Qlikview doesn't select Null values in fields, what i did was to fill this gap in the data.
Somthing like:
if( len(Table.status) = 0, "noStatus", Table.status)
Now I can select the field "noStatus" and Qlikview returns the original Null values selected 😉
Regards
Hatus