Although it's clear how to build a histogram using the CLASS function, I can't figure it out how to make a dimension using Class function in a straight table.
That's what I have now:
That's what I want to accomplish:
Have you seen this:
If you are still not able to figure it out, would you be able to share a sample where we might be able to help you out?
Yes, I have seen this.
I am able to replicate this on CHART, because CLASS is allowed to be used as DIMENSION on chart.
I am NOT able to replicate it in TABLE, because CLASS is not allowed to be used as DIMENSION in table.
My question is a general one: is it a limitation of QlikSense?
I have never tried this in Qlik Sense table, but I would not think that it won't work. Can you share a sample where this isn't working?
I was in process of making a sample app for you when I realized the reason.
Yes, CLASS can be used as Dimension.
My problem was resolved by adding AGGR
=class( aggr ( Sum(Sales), [Customer] ), 0.05)
Retrieving data ...