topic Select the unselected value in QlikView

Select the unselected value

Mon, 14 Dec 2009 21:45:30 GMT

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

Select the unselected value

Mon, 14 Dec 2009 22:35:51 GMT

Hi Santhosh,

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

Best regards.

Select the unselected value

Mon, 14 Dec 2009 23:51:22 GMT

Hi Miguel,

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

Select the unselected value

johnw — Tue, 15 Dec 2009 02:31:08 GMT

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.