Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
suresherks
New Contributor II

How to exclude the particular category chart in Qlicksense

Hi Team,

I want to remove 'Grocerys' section in this chart, can u please help me on this. how to write exclude expression

Exclude.jpg

3 Replies

Re: How to exclude the particular category chart in Qlicksense

What is your expression??

to exclude you try below syntax

Sum({<Product-={'Grocery'}>}Sales)

or use conditional dimension

If(not match(product,'Grocery'),Product)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
suresherks
New Contributor II

Re: How to exclude the particular category chart in Qlicksense

Hi Prashant,

Thanks, its working buddy.

Re: How to exclude the particular category chart in Qlicksense

Welcome, Please close the thread.

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.