# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:  Master

## rangesum(above( Expression get error

Hi All

I have a Current ratio expression from Table 1 which give me correct result. as below :-

((

,[Reporting Code] = {

">=50010<=

50090"

}

, month = ,year=>}[Amount]/\$(Columndim89))/1000))

/

((

,[Reporting Code] = {

">=70010<=

70070"

}

, month = ,year=>}[Amount]/\$(Columndim89))/1000))

March 2013 Current Ratio = 50.55% ( when month = 3 & year = 2013

Feb 2013 Current Ratio = 47.62% ( when month = 2 & year = 2013

Now my aim is plot the Current Ratio By MonthYear. what i need to do is to

convert the above expression into below , I remember stefan teach me once

in order for convert ratio into YearMonth i need to make use of rangesum :-

rangesum(above(

,[Reporting Code] = {

">=50010<=

50090"

}

, month = ,year=>}[Amount]/\$(Columndim89))/1000,0,rowno())))

/

rangesum(above(

,[Reporting Code] = {

">=70010<=

70070"

}

, month = ,year=>}[Amount]/\$(Columndim89))/1000,0,rowno())))

But i get error on the above expression , Hope some one can advise me how to do it.

Paul

0 Replies 