Select all but ONE (from Large set of Multiple Values) by Action

[vlad_komarov]

Hi,

I have a requirement to select multiple values in a field and I can resolve it by using 'Select in Field'->(AAAA|BBBB|CCCC).

Per article: http://community.qlik.com/message/65538#65538

It works fine until you need to select ALL values except ONE in the field with >30 potential values.

Any suggestions how to do it elegantly?

Thanks!

Vladimir

[#2 · Accepted solution]

First select the value, and second use the "Select Excluded" action.

Regards

[#3]

Hi,

Select the value you dont require using an action and then have a second action on the same field that does a select excluded.

Kind regards,

Footsie

[vlad_komarov]

Completely forgot about that option!

Thanks for helping me out!

Best regards,

Vladimir

[vlad_komarov]

Yes, it's elegant enough!

Thanks for helping me out!

Best regards,

Vladimir