Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show departments (DEPARTMENT_ID) with more than 30 employees (EMPLOYEE_ID). They given me the fields and functions to use in set analysis: EMPLOYEE_ID,DEPARTMENT_ID,DEPARTMENT_NAME,count(),concat().
Please help me out to solve this problem.
Thank you.
Hello @mithunr40
You can solve this problem by using Qlik's set analysis feature and the count() function to count the number of employees in each department. Then, you'll filter for departments that have more than 30 employees.
Here's an example of how you might do this in a chart. Suppose you want to create a bar chart with department names on the x-axis and the number of employees on the y-axis. In this case, you could use the following expressions:
Dimension: DEPARTMENT_NAME
Measure: count({<EMPLOYEE_ID = {"=count(EMPLOYEE_ID) > 30"}>} EMPLOYEE_ID)
This expression counts the number of employees in each department and only includes the count in the measure if the count is more than 30. The {<EMPLOYEE_ID = {"=count(EMPLOYEE_ID) > 30"}>} EMPLOYEE_ID
part of the expression is using set analysis to only include employee IDs in departments where the count of employee IDs is more than 30.
Please note that the actual syntax may vary depending on the specifics of your data and Qlik application. Be sure to replace the field names with the actual field names in your data if they are different.
Thank you for your response @Mike_Dickson but the output is wrong.
I have attached the image plz look into this.
Actually they have mention to use concat() aslo so i think the expression is different.