Need help in Class Function

Anonymous — Mon, 27 Feb 2017 07:48:58 GMT

Hi,

I have the following table:

And I have the following calculated dimension:

=Dual(Replace(Class(Sales,50,'x',5),'<= x <','-'),Class(Sales,50)) and one expression Sum(Sales)

As a result, I am getting the following result from Qlikview

Dimension Expression

5-55 50

55-105 350

155-205 200

But My understanding is:

Dimension Expression

5-55 50

55-105 100

105-155 250

205-255 200

Can someone explain what I am missing here?

Thanks,

Karthick S

Re: Need help in Class Function

avinashelite — Mon, 27 Feb 2017 07:53:17 GMT

Change the expression to Sales ..that will give the result your looking for