2 Replies Latest reply: Sep 7, 2018 10:41 AM by Gabor Tarnoczai RSS

    Relational Operator in Set Modifier

    Ashley Kuttler

      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.