topic Re: Why Expression after i add Aggr function , it return wrong value ? in QlikView

Why Expression after i add Aggr function , it return wrong value ?

paulyeo11 — Sat, 18 Jun 2016 06:02:46 GMT

Hi All I have below expression , return correct values :- '= money( SUM({}Amount*-1)/1000/$(Columndim89) , $(vMoneyFormatK)) Due to it does not display Total Sum , So I have modify the above expression with Aggr , but it return wrong value , May I know how to make it return correct value ? = money( Sum(Aggr(SUM({}Amount*1)/$(Columndim89)/1000, SOURCE)) , $(vMoneyFormatK)) Paul

Re: Why Expression after i add Aggr function , it return wrong value ?

paulyeo11 — Sat, 18 Jun 2016 06:07:09 GMT

Hi All

I have below expression , return correct value :-

money(

SUM({<year = {"$(=Max(year)-1)"},month={"<$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*-1)/1000/$(Columndim89)

, $(vMoneyFormatK))

Due to it does not display Total Sum , So I have modify the above expression with Aggr , but it return wrong value , May I know how to make it return correct value ? .

money(

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

, $(vMoneyFormatK))

Paul

Re: Why Expression after i add Aggr function , it return wrong value ?

paulyeo11 — Sat, 18 Jun 2016 06:14:34 GMT

my QV Doc

Re: Why Expression after i add Aggr function , it return wrong value ?

paulyeo11 — Sat, 18 Jun 2016 06:34:11 GMT

my QVF file