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: 
akuttler
Creator
Creator

Sum if with set modifier

Hello, I am trying to sum totals where transaction date is equal to service date.

The expression below works:

Sum(IF(TransactionDate = ServiceDate, Totals))


However I need to add a set modifier:

Sum(IF(TransactionDate = ServiceDate,{<Account = {'2000', '2004'}>} Totals))

But it gives me "error in expression"

Not sure where to place the set modifier in this scenario.

1 Solution

Accepted Solutions
sunilkumarqv
Specialist II
Specialist II

try below

Sum(  If(TransactionDate = ServiceDate, Totals)  {<Account = {'2000', '2004'}>}  )

View solution in original post

2 Replies
sunny_talwar

May be this

Sum({<Account = {'2000', '2004'}>} If(TransactionDate = ServiceDate, Totals))

sunilkumarqv
Specialist II
Specialist II

try below

Sum(  If(TransactionDate = ServiceDate, Totals)  {<Account = {'2000', '2004'}>}  )