Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

Relational Operator in Set Modifier

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.

1 Solution

Accepted Solutions
sunny_talwar

Try this

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

View solution in original post

2 Replies
sunny_talwar

Try this

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

View solution in original post

undergrinder
Specialist II
Specialist II

Hi Ashley,

TRy this:

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


G.