Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Exclude values in kpi

I am having problem to exclude values in KPI

I want to exclude all the C in "inspected grade"

 

And the same question for "transaction type" and "Status"

I want to exclude "try"  in transactions type

I want to exclude "Qouted" in "status"

See CSV file for example

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor III

Re: Exclude values in kpi

=Count({$<InspectedGrade-={'C'}>} InspectedGrade)

 

=Count({$-<InspectedGrade={'C'}>} InspectedGrade)

try both

Channa

View solution in original post

5 Replies
Highlighted
Valued Contributor III

Re: Exclude values in kpi

try use if(Not match(inspected grade,'*C*,inspected grade)

Channa
Highlighted
New Contributor

Re: Exclude values in kpi

Hi

if(Not Match ([Inspected Grade],'C*'),[Inspected Grade]) does not work 😞

 

Highlighted
Valued Contributor III

Re: Exclude values in kpi

u need to use some aggregate function it will not work with that expression i will come back 

Channa
Highlighted
Valued Contributor III

Re: Exclude values in kpi

=Count({$<InspectedGrade-={'C'}>} InspectedGrade)

 

=Count({$-<InspectedGrade={'C'}>} InspectedGrade)

try both

Channa

View solution in original post

New Contributor

Re: Exclude values in kpi

Thanks! It worked! 🙂