Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
davyqliks
Contributor

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

Re: Count a value in dimension

May be this

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

sasiparupudi1
Honored Contributor III

Re: Count a value in dimension

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

Highlighted
atkinsow
Valued Contributor II

Re: Count a value in dimension

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.])

Re: Count a value in dimension

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

robin_hausdoerfer
Valued Contributor III

Re: Count a value in dimension

doesn't

*fish* include fish* and *fish ?

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

Re: Count a value in dimension

Yes right we can other suggestion is also right.

Regards

Anand

davyqliks
Contributor

Re: Count a value in dimension

Thank you So much all.

Worked a treat.

Qlik Lover!