topic aggr() issue in QlikView

aggr() issue

newhere2014 — Thu, 03 Oct 2013 20:06:52 GMT

I want to use aggr() function to get total once for each key. The total is correct for each key, but they are not in the right position in a pivot table

I attached a test qvw.
Could anyone help with that? thanks.

Re: aggr() issue

Anonymous — Thu, 03 Oct 2013 20:21:42 GMT

Looks like this one works:

sum(

if(date2=aggr(min(date2),key, date1),aggr((sum(amount)),key))

)

Re: aggr() issue

abeyphilip — Fri, 04 Oct 2013 07:21:24 GMT

Hi,

It was getting sorted using date.

Changed the sort priority to be sorted using Key and then your 2nd expression value.

See if it helps.

Regards,

Abey

Re: aggr() issue

newhere2014 — Fri, 04 Oct 2013 15:28:18 GMT

Hi Michael,

Thanks for reply. It works in the test app. But when I use the formula in my real app, it fails. I attached my real app. Please take a look. Many thanks.

Re: Re: aggr() issue

Gysbert_Wassenaar — Fri, 04 Oct 2013 15:52:46 GMT

Add the nodistinct qualifier to the aggr function. See attached example.

Re: aggr() issue

newhere2014 — Fri, 04 Oct 2013 16:05:30 GMT

Thanks G and all of you.

Problem solved.