Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pm234567
Contributor
Contributor

SumIf Lookup Not sure at all

My Budget is the sum of sales from a historical sales Date.

In the main sales table the Date column has a corresponding BudgetDate against it so the link is present, just need to "lookup" the two.

I know not correct but simplistically put...

Sum({<[BudgetDate] = [Date]>} [Sales])

 

Capture.JPG

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I think you need to use Sum(if()) for this case. 

Sum(If(BudgetDate = Date, Sales, 0))

-Rob