topic Re: Aggr sum expression issue in QlikView

Aggr sum expression issue

irmantas — Sat, 16 Nov 2024 02:00:49 GMT

Hello,

I need Aggregate SUM from different tables. Like this simple ex:

I was use Aggr(sum(Purch),CustId=VendId) but expression do not works. Please help me.

Arthur_Fong — Thu, 07 Nov 2019 09:25:57 GMT

Try:
Aggr(sum(if(CustId=VendId,Purch)),CustId)

irmantas — Thu, 07 Nov 2019 11:15:02 GMT

Seems right, but in my real expression do not works.

irmantas — Thu, 07 Nov 2019 11:31:52 GMT

In my real situation, SUM have some IF's.

SUM(Purch) in really is: sum(if(DUEDATE<=Today(),Purch))

How i must change your expression to be correct?

Arthur_Fong — Thu, 07 Nov 2019 11:36:37 GMT

Try this:

Aggr(sum(if(CustId=VendId and DUEDATE<=Today(),Purch)),CustId)

irmantas — Thu, 07 Nov 2019 11:54:54 GMT

March better:) Expression works:)