Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
I have chart with dynamic dimension
=ValueList('Male','Female')
Expression shows count of total employees.
Currently is independent of this dimension , showing count of total employees in both row
Want to show decomposition of count of employees by gender.
Thanks in advance
Hi
ValueList is not linked to the fields in your model. You will have to create these links yourself. Let me show you by example.
Suppose that we have in our model, a fields called empID, empName, empGender; and that empGender contains either 'M' or 'F'. Now you create a table using dimension =ValueList('Male', 'Female') as you have done. Now create the expression:
Count(Distinct If(ValueList('Male', 'Female') = 'Male' And empGender = 'M', empID,
If(ValueList('Male', 'Female') = 'Female' And empGender = 'F', empID)))
You need to have the valuelist exactly as defined in the dimension.
HTH
Jonathan
Hi
ValueList is not linked to the fields in your model. You will have to create these links yourself. Let me show you by example.
Suppose that we have in our model, a fields called empID, empName, empGender; and that empGender contains either 'M' or 'F'. Now you create a table using dimension =ValueList('Male', 'Female') as you have done. Now create the expression:
Count(Distinct If(ValueList('Male', 'Female') = 'Male' And empGender = 'M', empID,
If(ValueList('Male', 'Female') = 'Female' And empGender = 'F', empID)))
You need to have the valuelist exactly as defined in the dimension.
HTH
Jonathan
Thanks Jonathan
It worked