topic Re: Select in Field Action on Text Object in QlikView

Select in Field Action on Text Object

Tue, 13 May 2014 14:17:59 GMT

How do I perform a NOT select in field action on a text object. When someone selects a text object ("button"), I want all values of a field selected except for one. I tried the "select excluded" but not too sure how that was all working.

For example, field name [fruit type] and I want everything but "apples".

Re: Select in Field Action on Text Object

Anonymous — Tue, 13 May 2014 14:22:25 GMT

Try two actions:
1. Select in filed "fruit type", value 'apples'

2. Select Excluded in "fruit type"

Re: Select in Field Action on Text Object

Tue, 13 May 2014 14:28:41 GMT

That worked, thanks.

Can you quickly explain to me the logic behind the "Select Excluded" action?

Re: Select in Field Action on Text Object

Anonymous — Tue, 13 May 2014 14:34:09 GMT

It inverses the field selections. That is, all values items in gray will be selected, and what was selected becomes excluded. So in your example, you select 'apples'. Next, you select anything except 'apples'.

Re: Select in Field Action on Text Object

Tue, 13 May 2014 14:43:07 GMT

thanks! makes sense