Class function Qliksense

[vvvvvvizard]

In Qlikview I would create a histogram by adding a bar chart , for dimension I would have eg  Class(Sum(Sales),1000)

for expression Count(Distinct Product_Name)

Now in Qliksense in a dimension if you say Class(Sum(Sales),1000) you receive an invalid dimension error , ,only Class(Sales,1000) is allowed which then gives the incorrect results

[petter]

only Class(Sum(Sales),1000)  will not work anyway it has to be written

=Class(Sales,1000)

[vvvvvvizard]

Why is the same product showing up in multiple bins , its should display in one bin only

[vvvvvvizard · Accepted solution]

= Class(Aggr(Sum({<QVTransTypeID={6}>} Units),ProductFullName),10)

Found the answer , had the aggr in the class function with the dimension name

[petter]

In this case you will have to use it like this as a measure:

=Class( Sum( {<QVTransTypeID={6}>} Units) , 10 )

or if you put a label on the third column and call it for instance UNITS you could write:

=Class( [UNITS] , 10 )

[petter]

The Aggr is not necessary if you do as I told you below... an Aggr is more costly performance-wise.....

Your formula will count the units independent of the date unless you include date as a dimension in your Aggr() function.