where clause on expressions

Thu, 16 Jul 2009 22:50:08 GMT

Hi There,

I need to generate 3 expressions that each have a different where clause bases on employee average age, female employee average age and male average age.

How can I used a where clause in an expression pivot table?

E.G.

Group Name Employee Avg Age Female Avg Age Male Avg Age
Group1 33.3 24.5 40.3
Group2 35.5 34.8 33.7

My detail contains employee number, gender and DOB.

Thanks,

Kevin.

where clause on expressions

Thu, 16 Jul 2009 22:58:48 GMT

Expression for

Female Avg Age =Avg( {$<Gender='Female'>} Age)

Male Avg Age = Avg( {$<Gender='Male'>} Age)

Try Employee Avg Age your self.

topic where clause on expressions in QlikView

where clause on expressions

where clause on expressions