Relational Operator in Set Modifier

[akuttler]

Hello I have an expression below:

Sum({<Account = {3000, 3001, 3002, 3003}, Days_in_AR <= {120}>} Totals) *-1

When I added the the "<=" Qlik says there is an error in my set modifier....what is the proper way to write this expression?

I want to sum totals for accounts under 120 days in AR.

Thanks.

[sunny_talwar · Accepted solution]

Try this

Sum({<Account = {3000, 3001, 3002, 3003}, Days_in_AR = {"<=120"}>} Totals) *-1

[undergrinder]

Hi Ashley,

TRy this:

Sum({<Account = {3000, 3001, 3002, 3003}, Days_in_AR = {"<=120"}>} Totals) *-1

G.