Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Why exchange conversion field must place after close the Bracket ?

Hi All

Below expression workinf fine :-

Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/1000/Rate, SOURCE))

Below expression is not working fine :-

Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1/Rate)/1000, SOURCE))

My question why i need to place the Rate after the ) and cannot place before that ?

Paul

1 Reply
paulyeo11
Master
Master
Author

my QV Doc