topic Re: SumIF To Set Analysis Help in QlikView

SumIF To Set Analysis Help

gauthamchilled — Fri, 15 Nov 2024 23:58:35 GMT

Hi,

Need a help in converting a sumif to set analysis. Below is the expression.

=sum(if([Trans Date] <= $(vAgeDate)
and $(vAgeDate) -[$(vBasis)] > vAge2
,[Sales]
))

where
Trans date is transactiondate
vAgeDate is AgeDate
vBasis is InvoiceDae
Vage2= 90

Can any body help?

Re: SumIF To Set Analysis Help

gauthamchilled — Wed, 16 Sep 2020 05:14:07 GMT

bump

Re: SumIF To Set Analysis Help

tresB — Wed, 16 Sep 2020 05:46:46 GMT

I assume, AgeDate and InvoiceDate are field. If so, I don't get how are they different from the variables. Are you using any aggregation function in the variable definitions? Could you explain with a sample ?

Re: SumIF To Set Analysis Help

gauthamchilled — Wed, 16 Sep 2020 05:55:26 GMT

Hi,

vAgeDate is max(AgeDate) but vBasis is just InvoiceDate field

Re: SumIF To Set Analysis Help

tresB — Wed, 16 Sep 2020 06:18:05 GMT

InvoiceDate has multiple dates? Are you expecting to select a single value from this field before an output comes?