topic Re: How can I trigger 'Select Excluded' on multiple field ? in QlikView

How can I trigger 'Select Excluded' on multiple field ?

Fri, 26 Jun 2015 12:25:05 GMT

How can I trigger 'Select Excluded' on multiple field ?

I can do it on one field at a time but I can't do it on multiple field together.

Is it possible ? or should I use a SetAnalysis in expression ?

Thanks for help.

Regards.

Re: How can I trigger 'Select Excluded' on multiple field ?

swuehl — Fri, 26 Jun 2015 12:44:14 GMT

I believe you can't do that with the standard action.

And if you add several actions of that type, the excluded values will change after each action is applied.

I assume you want to select the excluded values as seen before triggering the actions, right?

If you describe what you want to achieve in more detail, we can maybe help you find a different solution (maybe with set analysis, maybe something completely different).

Re: How can I trigger 'Select Excluded' on multiple field ?

oknotsen — Fri, 26 Jun 2015 12:56:37 GMT

Could you please describe the situation you are trying to solve? There might be a different solution.

With the limited information I have now, I would assume a nice Set Analysis statement.

Re: How can I trigger 'Select Excluded' on multiple field ?

Mon, 29 Jun 2015 07:11:51 GMT

Hello,

I have a country divided in Region, Province and City.

When I select Region, Province and City on the left part I would like to compare to the rest of the country on the right part.

See annexed image.

I try to get the rest of the country on the right part using an alternate state via triggers like below :

I do the same things for 'OnSelect' and 'OnChange', but this is working only for the first region that I select ???

So if I select one Region or one Province on the left part , I received the rest of the Country for the alternate state on the right part,

But it doesn't work when I select more than one Region or Province ???

It's like the 'Select Excluded' works only for a single value ???

As I am beginner with Qlik I don't know if it is normal or if I miss something ???

Regards.

Re: How can I trigger 'Select Excluded' on multiple field ?

swuehl — Mon, 29 Jun 2015 09:45:54 GMT

If you are using GetFieldSelections(), the returned value is not an appropriate search string when you are selecting multiple regions. Check the value in a text box to see what I mean.

You can use something like this as search string for a select in field action (without the need for an additional select excluded):

='("'&concat({1-$} DISTINCT City ,'"|"') &'")'

or a bit more complex but easier to write:

='=sum({<[City] = p({1-$} [City] ) >} 1)'

Re: How can I trigger 'Select Excluded' on multiple field ?

Tue, 30 Jun 2015 08:35:44 GMT

Thanks a lot swuehl.

It's running very well.

Re: How can I trigger 'Select Excluded' on multiple field ?

swuehl — Tue, 30 Jun 2015 09:27:30 GMT

You're welcome.

As a side note for future postings, it's common practice here in the forum to mark the original answer as correct or helpful, not yours.