Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to display

how to display count of employees in each department in the below table format

load * from employee;

load * from department;

departmentcount(employees)
sales10
HR10
finance25
corporate45
Total90

whenver I clik on concerned department those details are to be displayed in ohter table

i.e. when i click i slaes all the 10 records are to be displyed as below

departmentemployee numberEmplyee typesalarycountrymanager
sales1Regular40kINDXXX
sales2Temp50kINDYYYY
...............
sales10temp60kINDZZZZZ
1 Reply
Not applicable
Author

in script--

load *

from tablename;

load

department,

count([employee number])  resident tablename group by department;

****************************************

in expression--

Aggr(count([employee number]),department)