topic Re: Class function Qliksense in QlikView

Class function Qliksense

vvvvvvizard — Wed, 18 Apr 2018 10:28:12 GMT

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

Re: Class function Qliksense

petter — Wed, 18 Apr 2018 11:00:03 GMT

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

=Class(Sales,1000)

Re: Class function Qliksense

vvvvvvizard — Wed, 18 Apr 2018 13:23:45 GMT

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

Re: Class function Qliksense

vvvvvvizard — Wed, 18 Apr 2018 13:34:46 GMT

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

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

Re: Class function Qliksense

petter — Wed, 18 Apr 2018 13:48:27 GMT

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 )

Re: Class function Qliksense

petter — Wed, 18 Apr 2018 13:49:19 GMT

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.