Discussion Board for collaboration related to QlikView App Development.
I have three tables GENDER, AGE and EMPLOYEES.
What am trying to do is to count the number of employees per gender per age in a new table using the IDs of gender and age .
so the final result will be something like this :
Is it possible to do it with a qlickview script? I'm new to qlikview and I can't figure out how to do it.
May be like this
LOAD * INLINE [
ID_EM, GENDER, AGE
7, homme, 50
8, femme, 60
9, femme, 60
10, femme, 50
Left Join (NewTable)
Count(ID_EM) as Total
Group By ID_GENDER, ID_AGE;
DROP Table Gender, Age, Employees;
View solution in original post
Thank you for your answer that's exactly what i was looking for