Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Class function by date

I'm trying to use the Class function to show the count of client per representative, broken down by date. For example, I'm trying to show that in year 2009, 50 representatives had 3 clients, 24 representatives had 5 clients, and 17 reps had 6 clients. However, there are instances where a client will switch representatives over a year. Therefore, the class function isn't properly working when you drill down into the dates since it doesn't seem to take date into consideration.

My dimensions are Date and a calculated dimension of Aggr(Class(Count(distinct ClientNumber),1),[Representative Name]) and the expression is Count(distinct ClientNumber). Unfortunately I can't share data due to confidentiality, but is there any way of doing this better? Perhaps some sort of IF loop?

1 Solution

Accepted Solutions
Not applicable

Re: Class function by date

I managed to fix this by adding the Date to the Aggr calculation.


So my calculated dimension is now Aggr(Class(Count(distinct ClientNumber),1),[Representative Name], [Date])

2 Replies
MVP
MVP

Re: Class function by date

To be honest, I could not realize the usage of class() here. Could you share a sample app with dummy data set explaining the expected output?

Not applicable

Re: Class function by date

I managed to fix this by adding the Date to the Aggr calculation.


So my calculated dimension is now Aggr(Class(Count(distinct ClientNumber),1),[Representative Name], [Date])

Community Browser