topic Re: Class function by date in QlikView

Class function by date

Wed, 23 Oct 2013 16:40:35 GMT

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?

Re: Class function by date

tresB — Wed, 23 Oct 2013 17:03:05 GMT

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?

Re: Class function by date

Thu, 24 Oct 2013 15:40:29 GMT

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])