Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Very new to qlik sense. I am trying to build a chart that will show the percentage of female salary to male salary. I am going to show it in a few views and the measure is median salary.
For example
Department Gender Median (Salary) %
A Male 75000 96%
A Female 78000
How do i build the measure to show mediansalary by female gender / median salary male gender?
Thank you!
You could create Set Analysis expressions that calculate the MEDIAN Salary where Gender was Male and one for Female and compare them.
I've attached a workshop if you get really zealous to learn more about Set Analysis after checking out the help that is linked above.
Than you Dalton. This is really helpful. I built the formula to look like this which works perfectly.
Median({<[Person Gender]={'Female'}>}[Annualized Salary])
Do you know if there is a way to take it a step further and then take the further median by another breakdown?
Sample dummy data set:
BU Grade % Female Median Sal Male Median Sal
Sample1 A 103% 103000 100000
Sample1 B 92% 92000 100000
Sample1 C - 98000
Sample1 D 99% 99000 100000
MEDIAN 99%
I'd like to know how i build for formula to bring out the 99% for this sample BU...
Set Analysis allows you to use as many fields as you would like so if you literally want the D Grade which is 99% then just add it.
Median({<[Person Gender]={'Female'}, Grade = {'D'}>}[Annualized Salary])
According to the commonly quoted statistic, women make 77 cents for every dollar that men make. But many people ignore the reality that this is based on the mean salary of all women and men who work full-time. Occupational segregation is a phenomenon that describes how specific sexes predominate in certain occupations and pay stubs. In general, women prefer lower-paying professions, whereas men predominate in the film industry and child care. Many people believe that this is the result of women typically seeking employment with more flexibility in order to better combine work and family life.