Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

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

Regards

View solution in original post

4 Replies
Highlighted
Not applicable

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

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

Regards

View solution in original post

Highlighted
Not applicable

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

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

Highlighted
Partner
Partner

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

Completely forgot about that option!

Thanks for helping me out!

Best regards,

Vladimir

Highlighted
Partner
Partner

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

Yes, it's elegant enough!

Thanks for helping me out!

Best regards,

Vladimir