topic Re: Exclude from Current Selection in QlikView

Exclude from Current Selection

Thu, 14 Mar 2013 14:31:44 GMT

Hi foks,

I have a Multibox that I use to highlight options within a chart.

As this mutltibox is only used to highlight, and does not focus specifially on any option, I do not want any of the options selected from this multi box to appear in the current selections window.

Is is possible to exclude these selections from the 'current selections'?

Thanks

Re: Exclude from Current Selection

CELAMBARASAN — Thu, 14 Mar 2013 14:36:33 GMT

No you can't restrict that.

Re: Exclude from Current Selection

MayilVahanan — Thu, 14 Mar 2013 14:39:41 GMT

There is no option in currect selection box, but you can exclude in the chart expression using set selection.

Current selections box -> used to display all the selected item in the document.

If you use alternate state for that multiple box, you can do it

Re: Exclude from Current Selection

Thu, 14 Mar 2013 14:42:03 GMT

When you say that the multi-box is only used to show options in a chart, it sounds like you may want to use a Hide Prefix in your script. This way the field will not show up in the Current Selections box. See attached.

Re: Exclude from Current Selection

Thu, 14 Mar 2013 14:50:00 GMT

Hi Tony,

PFA, Try this hope it is helpful.

Regards,

Nirmal.

Re: Exclude from Current Selection

Thu, 14 Mar 2013 16:16:31 GMT

Nirmal,

This is exactly what I am trying to do.

How exactly have you achieved this?

Re: Exclude from Current Selection

Thu, 14 Mar 2013 17:25:02 GMT

I have created an alternate State and the multibox options can now be selected without being included into the Current Seletions Window.

However, the expression that I am useing within my chart to highlight the background colour of a cell based on the the mutlibox selections, no longer works.

=If([Peer Group]= [Peer Group2], rgb(200,255,200),If([PEERSCORES.RETAIL_REGION_NAME]= [Region2], rgb(200,255,200),))

In the Expression above 'Peer Group2' and 'Region2' are both of the Multiboxes in questions. Seeing as how I have created an Alternate State for then now (G1). Is there an ammendment I will need to make to this expression so that it will continue to work based on the selctions of either of the multiboxes?

Re: Exclude from Current Selection

Fri, 15 Mar 2013 04:14:26 GMT

Hi tony,

Is this Helpful answer or correct answer.

Regards,

Nirmal.