topic Re: Count a value in dimension in QlikView

Count a value in dimension

davyqliks — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following working

count(DISTINCT([Online Order NO.]))

However I really need to just 'count' 1 value in the dimension like 'fish' from the dimension [Online Order NO.]

How can I achieve this, thank you. I will be checking results UK AM tomorrow.

Thank you in advance

Qliks

sunny_talwar — Wed, 16 Aug 2017 16:07:16 GMT

May be this

Count({<DimensionName = {'fish'}>} DISTINCT [Online Order NO.])

sasiparupudi1 — Wed, 16 Aug 2017 18:33:20 GMT

count({<Dimension={'fish*'}>}DISTINCT([Online Order NO.]))

Anonymous — Wed, 16 Aug 2017 19:38:59 GMT

The others responses are probably what you really wanted. But based on how I read your question it would be:

Count({<[Online Order NO.]= {'*fish*'}>} DISTINCT [Online Order NO.])

its_anandrjs — Thu, 17 Aug 2017 08:00:19 GMT

Hi,

From your question it seems you have count values from the dimension [Online Order NO.] if So then try this way

By If Condition

Count( If( WildMatch( [Online Order NO.], '*fish','*fish*','fish*' ), DISTINCT [Online Order NO.] )

By SET Analysis

Count( {< [Online Order NO.] = {*fish} >} DISTINCT [Online Order NO.] )

Count( {< [Online Order NO.] = {*fish*} >} DISTINCT [Online Order NO.] )

Count( {< [Online Order NO.] = {fish*} >} DISTINCT [Online Order NO.] )

Regards,

Anand

Anonymous — Thu, 17 Aug 2017 08:03:34 GMT

doesn't

*fish* include fish* and *fish ?

--> ok I understand, you tried to show alternatives...

its_anandrjs — Thu, 17 Aug 2017 08:10:44 GMT

Yes right we can other suggestion is also right.

Regards

Anand

davyqliks — Thu, 17 Aug 2017 10:50:02 GMT

Thank you So much all.

Worked a treat.

Qlik Lover!