topic Re: Value list in Dimension in QlikView

Value list in Dimension

Wed, 23 Oct 2013 06:57:10 GMT

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

Re: Value list in Dimension

jonathandienst — Wed, 23 Oct 2013 07:12:51 GMT

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

Re: Value list in Dimension

Wed, 23 Oct 2013 07:16:55 GMT

Thanks Jonathan

It worked