Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
karthick01
Contributor III
Contributor III

Need help in Class Function

Hi,

I have the following table:

 

CustomerKeySales
1100
3200
7120
850
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

1 Reply
avinashelite

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