Discussion board where members can get started with Qlik Sense.
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
View solution in original post
try use if(Not match(inspected grade,'*C*,inspected grade)
if(Not Match ([Inspected Grade],'C*'),[Inspected Grade]) does not work 😞
u need to use some aggregate function it will not work with that expression i will come back
Thanks! It worked! 🙂