Order / Where in KPI objects

[#1]

Hello evereyone,

I'm really new to Qlik and until now I really like it a lot.

Now i've come to a question that I can't seem to find an answer for.

I would like to show (in an KPI) a number of Exams.

So far so good. It's working fine. But I want that this KPI only shows the Exams where the Datafield "Exam Name" contains a string like "%head%" in SQL. Is this even possible or do I have to create a completly new Dataset with those values?

I hope that you understand my Problem and anyone can help me there.

Cheers

Alex

[#2 · Accepted solution]

You are looking for wildcard set analysis, so would look something like:

Count(

{$

<

[Exam Name] = {'*head*'}

>

}

[Exam Result])

[#3]

Thank you very much, that did the trick. And thanks for pointing me to the wildcard set analysis. I didnt know what I should search for.