Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
when only
one year selected
two or both year selected
Single Month selected
Multiple months Selected
Single Month and a year selected
Multiple months and a year Selected
Single Month and both years selected
Multiple months and both years Selected
Not sure I understand the output you are looking to get, would you be able to provide the expected output for the sample attached?
Are you looking for something like this.
Expecting Pre aggregated Distinct Employee Count for the below filter selection scenario
when only
one year selected
two or both year selected
Single Month selected
Multiple months Selected
Single Month and a year selected
Multiple months and a year Selected
Single Month and both years selected
Multiple months and both years Selected