Discussion Board for collaboration on QlikView Layout & Visualizations.
For Ex: If I have data as below in the table
MONTH, MEAL_TYPE, SPEND, EMPLOYEE_ID
I would like get the total count of employees who had spent greater than 5 in each meal_type category for each month
So I have MONTH and MEAL_TYPE as Dimensions in chart and in expression, I have formula as below.
It's returning 1 always. If I just have Count (DISTINCT EMPLOYEE_ID), It's working , but I need results only where SPEND > 5
I cannot filter at the Table level as I may need all records in another chart.
Please let me know how can i resolve the above issue.
Go to Solution.
I could resolve it by the below formula
=((COUNT(DISTINCT( if([SPEND] > 5,[EMPLOYEE_ID])))))