Distinct pre Aggregate data on a field based on Year and Month combination.
We have an Qlik Sense application with 2 Million distinct <Employee> in a 6 Million rows of Fact Table and need to perform several calculations that using <Count Distinct Employee> in the denominator. E.g. (<Total Amount> /<count distinct Employee>)
Application Year and Month are the Filters.
Sample Qlik sense application (YrlyMonthlyDailyDistinctEmpCount) with sample data are as attached.
Please let me know the solution to pre aggregate <Count Distinct Employee> based on Year and Month combination.
Expecting Pre aggregated Distinct Employee Count for the below filter selection scenario