topic Re: Order / Where in KPI objects in App Development

Order / Where in KPI objects

Wed, 28 Oct 2015 09:52:28 GMT

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

Re: Order / Where in KPI objects

Wed, 28 Oct 2015 14:45:01 GMT

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

Count(

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

}

[Exam Result])

Re: Order / Where in KPI objects

Wed, 28 Oct 2015 14:55:02 GMT

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.