Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
peschu123
Partner - Creator III
Partner - Creator III

Exclude selected values

Hi,

is there a possibility to exclude single values. Look at this chart:

qv_chart.jpg

I would like to give the users the opportunity to exclude for example this value(via listbox for example). This would make it much easier to read the chart. I don't want to "hardcode" something because its necessary to see those extraordinary values too.

Best Regards,

Peter

1 Reply
Gysbert_Wassenaar

You can select the single value in the listbox and then right click the listbox and choose Select Excluded to invert the selection. To make it easier to select multiple values you can choose a checkbox style on the Presentation tab for Selection Style Override.

If you're using QV11 you could also create an alternate state for the listbox. You can then select the exceptions in that listbox. You'll need to change the chart expression to make use of the alternate state. For example if you have an expression count(Amount) that would become count({$-[AltStateName]} Amount)


talk is cheap, supply exceeds demand