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: 
Not applicable

SUM / IF in expressions statement

I'm new to CV and trying to sum a value if another 2 values are meet, it does not work !!!

My formula is as follow

sum({$<month.budget.date = monthsig, year.budget.date = yearsig>} SUM in expressios on statement)

which translate in if my budget dates (month.budget.date  and year.budget.date ) match by signature date (monthsig and yearsig) , then I would like top plot the TCV (contract value)

1 Reply
chematos
Specialist II
Specialist II

You have to make sure that your date fields have the same format.

Contract Value would be the field you want to calculate

sum({$<month.budget.date = {"monthsig"}, year.budget.date = {"yearsig"}>} [Contract Value])