Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Tags (1)
1 Reply
Not applicable

Re: how to display

in script--

load *

from tablename;

load

department,

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

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

in expression--

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

Community Browser