Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

Count a value in dimension

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

7 Replies
sunny_talwar

May be this

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

sasiparupudi1
Master III
Master III

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

Anonymous
Not applicable

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
Not applicable

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
Specialist
Specialist
Author

Thank you So much all.

Worked a treat.

Qlik Lover!