Adding Set Analysis to Sum(aggr())

poojask123 — Thu, 09 Nov 2017 11:31:11 GMT

Hi,

I have the below expression to calculate a weightage.

=NUM(SUM(((aggr(avg(num([Check Date])-num([Invoice Date])),[KEY_CompanyInvoiceNumberVendorNum]))*[Invoice $]))/

(Sum(IF(aggr(([Check Amount]),[Check Number])>0, aggr(([Check Amount]),[Check Number]),Aggr(sum([Gross Amount]),[Check Number])))),'#,##0')

This expression should be modified to add a set analysis like below, into the above expression:

{<Check_Date = {'>= $(vYearStart) <= $(vYearEnd)'}>}

Please help.

Thanks

Pooja

Re: Adding Set Analysis to Sum(aggr())

Anonymous — Thu, 09 Nov 2017 11:54:27 GMT

Within the first sum:

=NUM(SUM({<Check_Date = {'>= $(vYearStart) <= $(vYearEnd)'}>} ((aggr(avg(num([Check Date])-num([Invoice Date])),[KEY_CompanyInvoiceNumberVendorNum]))*[Invoice $]))/

(Sum(IF(aggr(([Check Amount]),[Check Number])>0, aggr(([Check Amount]),[Check Number]),Aggr(sum([Gross Amount]),[Check Number])))),'#,##0')

topic Re: Adding Set Analysis to Sum(aggr()) in QlikView

Adding Set Analysis to Sum(aggr())

Re: Adding Set Analysis to Sum(aggr())