Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage of totals

Is there a way for me to take the set analysis function 

Count({<IND={A}>} Ethnic)

and use it to get the percentage of ethnicity based on the total of all ethnicity?

Example

Asian     432     43.7%

Black     196     19.8%

Hispanic 360     36.4%

  TOTAL  988   100.0%

I want to find out what is the percentage of Asian, Black, Hispanic, etc based on the total.

Thanks

Mauricio

1 Solution

Accepted Solutions
Not applicable
Author

Count (Ethnic) / Count(TOTAL Ethnic)

View solution in original post

2 Replies
Not applicable
Author

Count (Ethnic) / Count(TOTAL Ethnic)

Not applicable
Author

Thanks KSCHIECK.  That steered me in the right direction.  Since I was using the set analysis to differentiate between my active and inactive populations, I wanted to get percent totals for each one. 

 

Count ({<[IND]={A}>} [Ethnic])/Count(TOTAL{<[IND]={A}>} [Ethnic])

Thanks again!

Mauricio