rangesum(above( Expression get error

paulyeo11 — Mon, 06 May 2013 08:11:49 GMT

Hi All

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

((

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=50010<=

50090"

}

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

((

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[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(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=50010<=

50090"

}

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

rangesum(above(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[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

topic rangesum(above( Expression get error in QlikView