Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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