topic Re: aggr expression error in QlikView

aggr expression error

didierodayo — Wed, 11 Jan 2017 02:01:24 GMT

Hello,

my expression below isn't working when I try to add a condition. Please where is my mistake?

WORKING

=aggr(sum(building),Date)

ERROR:

sum(Aggr(If(growthdate=builddate,building),Date))

Thanks

Re: aggr expression error

petter — Wed, 11 Jan 2017 03:17:48 GMT

I think you should try this:

Aggr( Sum( If( growthdat=builddate, building ) ) , Date )

Re: aggr expression error

sunny_talwar — Wed, 11 Jan 2017 03:19:00 GMT

Without knowing too much, may be this:

=Sum(Aggr(If(growthdate = builddate, Sum(building)),Date))

Re: aggr expression error

petter — Wed, 11 Jan 2017 03:20:13 GMT

Aggr( Sum( {<UniqueID={"=growthdate=builddate"}>} building ) , Date )

I don't know which field in the table that contains the field building that might qualify for a unique row id. But I just called it UniqueID and you have to replace it accordingly.