Discussion Board for collaboration related to QlikView App Development.
Hello, I guess my question is very easy, still can't find solution..
I have table:
I need to get count of all unique Nr2 for each class.
I use Count(nr2) and get sum of all rows - the result is 7
But I need only count unique Nr2 .. and the result must be 5. How can I modify my COUNT?
View solution in original post
May be one of these:
Count(Aggr(Count(Distinct nr2), Class))
Thanks to all of you!