topic Event triggers - selection action - values exclusion and white spaces management in QlikView

Event triggers - selection action - values exclusion and white spaces management

googel84 — Tue, 11 Jan 2011 12:35:40 GMT

Hi all, I'd need a help with the use of event triggers and multiple values selection.

I have two goals:

Selecting more than one value containing white spaces (' ') using a selection action ("Select in Field" or "Toggle Select" for example)
Excluding one of the possible values from the selection made

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:

Is there a way to indicate just the values to be excluded?
Which is the right syntax to manage spaces inside values?

Thanks a lot.

Event triggers - selection action - values exclusion and white spaces management

googel84 — Tue, 18 Jan 2011 11:59:26 GMT

Any suggestion?

AW:Event triggers - selection action - values exclusion and white spaces management

Hatus — Fri, 04 Feb 2011 15:29:08 GMT

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