Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gilldilpreet
Contributor III
Contributor III

Using set analysis to create a percentage

Hi, 

I have used the following set analysis as an expression to create the total FTE for a specific year against a dimension (e.g. gender) in a pivot table: sum({$<[ACYEAR]={"2018/19"}>}[FTE]).

I would now like to convert this number into a percentage i.e. total FTE of a gender for 2018/19 / total FTE for 2018/19 * 100. 

Can anyone help on this please? 🙂 

Many thanks

Dilpreet

 

Labels (1)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

use

sum({$<[ACYEAR]={"2018/19"}>}[FTE])

/ sum({$<[ACYEAR]={"2018/19"}>}total [FTE]) *100

Regards

View solution in original post

1 Reply
martinpohl
Partner - Master
Partner - Master

use

sum({$<[ACYEAR]={"2018/19"}>}[FTE])

/ sum({$<[ACYEAR]={"2018/19"}>}total [FTE]) *100

Regards