Discussion board where members can get started with QlikView.
Need a help in converting a sumif to set analysis. Below is the expression.
=sum(if([Trans Date] <= $(vAgeDate)and $(vAgeDate) -[$(vBasis)] > vAge2,[Sales]))
whereTrans date is transactiondatevAgeDate is AgeDatevBasis is InvoiceDaeVage2= 90
Can any body help?
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 ?
vAgeDate is max(AgeDate) but vBasis is just InvoiceDate field
InvoiceDate has multiple dates? Are you expecting to select a single value from this field before an output comes?