Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
luxlux80
Contributor III
Contributor III

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

     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

3 Replies
sunny_talwar

Not sure I understand the output you are looking to get, would you be able to provide the expected output for the sample attached?

neelamsaroha157
Specialist II
Specialist II

Are you looking for something like this.

luxlux80
Contributor III
Contributor III
Author

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