Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

Highlighted
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