Need help in Class Function

[Anonymous]

Hi,

I have the following table:

CustomerKey	Sales
1	100
3	200
7	120
8	50
9	130

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

[avinashelite]

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