topic Re: Select All Values and exclude a Value on a List Box in QlikView

Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:10:35 GMT

Hi all,

When the qvw document opens, I need select All values and exclude a determinate Value on a List Box. Is it possible with a trigger or a macro? or other way?

Thanks,

Ricardo

Re: Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:16:27 GMT

You can use triggers. See attached.

Re: Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:29:47 GMT

Perfect! Thanks.

Now I have other question (+10 points) How can I Select All and exclude two o more values?

Regards,

Ricardo

Re: Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:35:44 GMT

Same way. You just have to use a vertical bar. See attached.

Re: Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:44:16 GMT

I did not know.

Thanks Rebecca! it Works.

But I can give you other 10 points, the forum doesn't allow. I thought I could do. I will check "Useful Answer". I owe you 5 points.

Thanks,

Ricardo

Re: Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:52:23 GMT

Glad I could help.

Re: Select All Values and exclude a Value on a List Box

Thu, 14 Mar 2013 15:54:45 GMT

ha ha ha, other 5 points!