Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Order / Where in KPI objects

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

Tags (4)
1 Solution

Accepted Solutions
Not applicable

Re: Order / Where in KPI objects

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

Count(

{$

<

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

>

}

[Exam Result])

2 Replies
Not applicable

Re: Order / Where in KPI objects

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

Count(

{$

<

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

>

}

[Exam Result])

Not applicable

Re: Order / Where in KPI objects

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.