Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select the unselected value

Hi,

I want to select a field in the multibox, is it possible to display an object with the not selected values of the field in the multibox.

To make it clear, If I have a field called code and it has three values like 'ID', IN', 'IS'. Now if I select 'ID', I want the object should be effective for 'IS' and 'IN' (not selected value).

Please look at the attachment. I want to have to the obj1 should have the selected value and obj2 should have not selected value.

--Santhosh

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

Yep, that used set analysis. Attached is one way to handle it without set analysis. It can get pretty slow for large data sets, so use this approach with caution, but I'm not sure how else to solve your problem until you upgrade to 8.5 or 9.0.

View solution in original post

3 Replies
Not applicable
Author

Hi Santhosh,

Here you are my solution, I hope it help you.

Best regards.

Not applicable
Author

Hi Miguel,

I get an error in the expression. Did you use set analysis concept? I am using version 8.2.

johnw
Champion III
Champion III

Yep, that used set analysis. Attached is one way to handle it without set analysis. It can get pretty slow for large data sets, so use this approach with caution, but I'm not sure how else to solve your problem until you upgrade to 8.5 or 9.0.