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
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
mg862925
Contributor
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
Channa
Specialist III
Specialist III

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

 

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

try both

Channa

View solution in original post

5 Replies
Channa
Specialist III
Specialist III

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

Channa
mg862925
Contributor
Contributor
Author

Hi

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

 

Channa
Specialist III
Specialist III

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

Channa
Channa
Specialist III
Specialist III

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

 

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

try both

Channa

View solution in original post

mg862925
Contributor
Contributor
Author

Thanks! It worked! 🙂