Excluding values in a chart

[#1]

Hi,

I have a database with a column that includes the values "J" "N" "S". When I create a chart for example I'd like to exclude the values "S". How do I do that? If anyone also know where I can find information like this it would be really helpful. Thanks.

[sunny_talwar]

Try this in your set analysis:

{<ColumnName -= {'S'}>} or

{<ColumnName = e({<ColumnName = {'S'}>})>}

Both of the above will behave differently when you make a selection. Try them out and see which one of them satisfy your needs.

HTH

Best,

Sunny

[sunny_talwar]

[Gysbert_Wassenaar]

You could add a set filter to your expressions. For example sum(Amount) would become sum({<MyDim-={'S'}>}Amount)

[Alexander_Thor]

Hey Maria,

Sunny and Gysbert already provided great answers which should solve your issue.

If you want to get more familiar with Set Analysis I would recommend you check out this article from the Help documentation https://help.qlik.com/sense/2.1/en-US/online/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-a...

Or check out the following videos around the topic Beginners' Introduction to Set Analysis - Qlik Sense and QlikView - YouTube

Good luck!

[#6]

Thanks guys. I'm getting such great help here

[sasiparupudi1]

Try

{<FieldName={'*'}-{'S'}>}

Please close this thread by marking a correct answer so that it will be helpful for others

Sasi