I am having trouble creating a table in qliksense expressed in percentages. My raw data are like the following:
YEAR
NUM
NAME
NEW
AGE
2017
1
JOHN
YES
0-2
2017
2
JOHN
NO
3-5
2019
1
ROBERT
YES
6-10
2017
1
CLAIRE
NO
11-17
2016
1
ALEX
YES
0-2
2016
3
JULIA
NO
3-5
I want to createatable 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))))
ButI am really having trouble to calculate the same value in percentage. I studied the function TOTAL, but it does not work with IFS, soitried with something like this after navigating on different forums