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
