Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MuruKesavan
Contributor
Contributor

Exclude certain filters

Hi,

I'm trying to exclude certain data from this filter, i.e, all except Email. Can you please help me to edit expression to enable this function, below is the field and expression.

=[Profile Communication Type]

MuruKesavan_0-1631619711721.png

 

3 Replies
AshutoshBhumkar
Partner
Partner

Hi,

What is the expression you are writing in the straight table?

Like if you are adding Sum(Sales) and if you want to exclude 'EMAIL' Communication Type, then maybe you can write an expression like Sum({<[Communication Type] -= {"EMAIL"}>}Sales).

 

MuruKesavan
Contributor
Contributor
Author

Hi,

No, I'm trying to set it to show only EMAIL as the only filter / rest to be excluded from this report.

AshutoshBhumkar
Partner
Partner

Hi,

Well, if you want to show only for EMAIL, you can restrict data in backend script.

Put in where condition like,

Load * where [Communication Type] = 'EMAIL';