Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paisleymike
New Contributor III

Measures containing a certain value

Hello

I am looking to count the number of instances which contain a certain value.

i.e. Count the number of instances which contain 'S0101'

Thank you

3 Replies
ogster1974
Honored Contributor II

Re: Measures containing a certain value

Something like

Count({<instance={'S0101'}>} instancekey)

paisleymike
New Contributor III

Re: Measures containing a certain value

That was it but needed to add a * after the S0101

Count({<instance={'S0101*'}>} instancekey)

That counted all the ones which contained S0101

Thank you

Highlighted
ogster1974
Honored Contributor II

Re: Measures containing a certain value

Glad I could help, The wildmatch function can be useful around this topic too.

Regards

Andy