Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
jaymeknapp
Contributor III
Contributor III

Using < or > in a Set Expression

I'm trying to pull only transactions where the BackOrder Quantity is >=1..  Here is the expression I have so far, not sure how to use the >= expression.

COUNT(

               {$<[Transaction Order Status]={'Open'},

                    [Items Item Category]={'Catalog'},

                      [Transaction Type]={'Sales Order'},

                        [Transaction Line Backorder Flag]={1},

                          [Transaction Line Backorder Quantity] {'=> 1'}, 

                            [Transaction Line Expected Ship Date]={'<$(=num(date(today()-1)))'}>}

   

    [Transaction Line Backorder Quantity]

)

1 Reply
sunny_talwar

May be try to place the = sign after < or > and add an equal sign after the field name you testing the condition against...

COUNT(

              {$<[Transaction Order Status]={'Open'},

                    [Items Item Category]={'Catalog'},

                      [Transaction Type]={'Sales Order'},

                        [Transaction Line Backorder Flag]={1},

                          [Transaction Line Backorder Quantity] = {">=1"},

                            [Transaction Line Expected Ship Date]={'<$(=num(date(today()-1)))'}>}

    [Transaction Line Backorder Quantity]

)