Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Excluding values in a chart

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.

Tags (1)
6 Replies
MVP
MVP

Re: Excluding values in a chart

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

MVP
MVP

Re: Excluding values in a chart

Capture.PNG

Re: Excluding values in a chart

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

akl
Honored Contributor

Re: Excluding values in a chart

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!

Not applicable

Re: Excluding values in a chart

Thanks guys. I'm getting such great help here

sasiparupudi1
Honored Contributor III

Re: Excluding values in a chart

Try

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


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


Sasi