Count a value in dimension

[davyqliks]

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]

May be this

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

[sasiparupudi1]

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

[Anonymous]

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]

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]

doesn't

*fish* include fish* and *fish ?

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

[its_anandrjs]

Yes right we can other suggestion is also right.

Regards

Anand

[davyqliks]

Thank you So much all.

Worked a treat.

Qlik Lover!