Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
New Contributor III

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
Valued Contributor II

Re: Sum if with set modifier

try below

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

2 Replies
MVP
MVP

Re: Sum if with set modifier

May be this

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

sunilkumarqv
Valued Contributor II

Re: Sum if with set modifier

try below

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