Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

rangesum(above( Expression get error

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

0 Replies