Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

SumIF To Set Analysis Help

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?

Labels (1)
4 Replies
Highlighted
Creator
Creator

bump

Highlighted
MVP
MVP

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 ?

Highlighted
Creator
Creator

Hi,

 

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

 

Highlighted
MVP
MVP

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