Discussion Board for collaboration related to QlikView App Development.
I have this load script
MyTable:LOAD * INLINE [Ename,Egender,DeptJohn,M,10Hank,N,10Jill,F,20Frank,M,20Joan,F,20Chris,M,30];
This results in this straight table
Ename Egender DeptChris M 30Frank M 20Hank M 10Jill F 20Joan F 20John M 10
I would like an extra column emp_count_in_dept_with_current_selection with the number of employees in each department in the current selection of my data so
the desired result would be
Ename Egender Dept emp_count_in_dept_with_current_selectionChris M 30 1Frank M 20 3Hank M 10 2Jill F 20 3Joan F 20 3Anna F 10 2
And when I select F in the straight table I want
Ename Egender Dept emp_count_in_deptJill F 20 2Joan F 20 2Anna F 10 1
Count( total <Dept> Ename)
View solution in original post
Thank you very much!