topic Re: Exclude values selected in a list box from the sheets objects in QlikView

Exclude values selected in a list box from the sheets objects

mohamed_ahid — Tue, 26 Aug 2014 15:57:51 GMT

hi all ,

i'm trying to perform a list box in which the value selected will be excluded from all the sheets (all the application) .

One solution is to do that with set analysis i think (apply this on all the objects of the application) .

the seconde one is to use a trigger wich reverse the selection every time i (make choice) activate the liste box

is there another solution to do that ?

thx

m_woolf — Tue, 26 Aug 2014 16:34:05 GMT

After selecting the item to exclude, the user can right-click and Select Excluded.

mohamed_ahid — Wed, 27 Aug 2014 07:29:00 GMT

Thx Micheal.

But this solution is too heavy for the user ,especially that this filter will be used only for exlusion .

any help plz.

ashfaq_haseeb — Wed, 27 Aug 2014 07:43:42 GMT

Hi,

One of the work around.

In first i/p box select id you want to exclude.

Then In Second i/p box enter any number to select excluded value.

Regards

ASHFAQ

mohamed_ahid — Wed, 27 Aug 2014 07:50:52 GMT

Thx Mohammed but i didn't get your idea !

ashfaq_haseeb — Wed, 27 Aug 2014 07:58:56 GMT

Hi,

Let say that you want to exclude 10 20 30 from CustomerID list box

Download the attach file

In first i/p box type 10 20 30 --> Then hit enter, It will select values 10 20 30 from CustomerID list box.

Second step type any number in second i/p box --> type any number let say 50 hit enter.

Now it will exclude your previous selection. i.e from CustomerID list box everything is selected except 10 20 30.

Hope it helps

Regards

ASHFAQ

mohamed_ahid — Wed, 27 Aug 2014 08:03:12 GMT

i think using a trigger is more simple .

THX Mohammed