Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rish
New Contributor II

Categorical Field count

Suppose I have following data in an excel:

Column A

ABC

ABC

XYZ

and I want to display the ratio of occurences of ABC to XYZ(2:1) along with no. of occurences or "Count" of ABC(2), how do i write an expression for it?

1 Solution

Accepted Solutions
Partner
Partner

Re: Categorical Field count

 

Count

Count( {<[Column A]={ 'ABC'} >}[Column A])

Ratio

Count( {<[Column A]={ 'ABC'} >}[Column A]) / Count( {<[Column A]={ 'XYZ'}>}[Column A])

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Partner
Partner

Re: Categorical Field count

 

Count

Count( {<[Column A]={ 'ABC'} >}[Column A])

Ratio

Count( {<[Column A]={ 'ABC'} >}[Column A]) / Count( {<[Column A]={ 'XYZ'}>}[Column A])

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

rish
New Contributor II

Re: Categorical Field count

Thanks vegar. It worked
Partner
Partner

Re: Categorical Field count

Glad to be of help ☺️

— Vegar
Plees ekskuse my Swenglish and or Norweglish spelling misstakes