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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
federicagaiarossi
Contributor
Contributor

How to create table and graph in percentage

I am having trouble creating a table in qliksense expressed in percentages. My raw data are like the following:

YEARNUMNAMENEWAGE
20171JOHNYES0-2
20172JOHNNO3-5
20191ROBERTYES6-10
20171CLAIRENO11-17
20161ALEXYES0-2
20163JULIANO3-5
 

I want to create a table that shows the number of new people per year among the different ages, both in absolute values and in percentage (of the total new students of each year). I am using the following code to calculate the absolute value

Count(IF(NUM=1 and [NEW STUDENT]='YES', ((NAME))))

But I am really having trouble to calculate the same value in percentage. I studied the function TOTAL, but it does not work with IFS, so i tried with something like this after navigating on different forums

Count(IF(NUM=1 and [NEW STUDENT]='YES', ((NAME))))
/
Count(TOTAL {<[NEW STUDENT] = {'YES'}>} {<[NUM] = {1}>}  NAME)

But It's still not it and I am missing something in the logic.

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps like this:
Dimension: YEAR
Measure: Count({<NEW={1}>}  NAME) / Count(NAME)

Not sure what the NUM field means and what uniquely identifies a person.


talk is cheap, supply exceeds demand