topic Re: Need help with Aggregating data in QlikView

Need help with Aggregating data

ajaysingh29 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have attached test QVW, need help to get result in 2 pivot tables.

Below expression are not working:

1) Aggr(sum(Amt)*(Pdate-Ddate),DocumentType,[Doc Des],[Late - On Time],Year,month)

2) Aggr(sum(Amt)*(Pdate-Ddate),DocumentType,[Doc Des],[Late - On Time],Year,month)/sum(amt)

Thank you!

Re: Need help with Aggregating data

jmvilaplanap — Fri, 07 Jul 2017 10:07:10 GMT

I tried to see what values has Pdate - Ddate, but almost always is null:

I think you have to fix this first.

Regards

Re: Need help with Aggregating data

jmvilaplanap — Fri, 07 Jul 2017 10:09:10 GMT

Ahh, and you can't use Aggr function as "final aggregation", if you need the sum, with this sum(Amt)*(Pdate-Ddate) is enough.

Re: Need help with Aggregating data

Kushal_Chawda — Fri, 07 Jul 2017 10:41:10 GMT

You have multiple instances of your Dates for each dimension of your Pivot. So you need to consider either Min or Max date for all possible combination like below

sum(Amt)* (max(Pdate)-max(Ddate))