11 Replies Latest reply: May 8, 2018 10:32 AM by Krithika Rees RSS

    Where clause in Qlik Sense Script

    Krithika Rees

      Hello All,


      I am noticing that only the first where clause condition is being executed and the rest is ignored. Is there a reason why Qlik Sense does this? Or is there anything wrong with my script?




      Thanks in advance









      From (lib://qvdstage1/abcd/accc.QVD)(qvd)


      [Controlling Area_CO_AREA]= 'VMS1' or '#' and

      [Chart of accounts_CHRT_ACCTS] = 'VSM1' and

      [Fiscal Year Variant_FISCVARNT] = 'V8' and

      ([Clearing Date]='' or num(Today(2))- num([Clearing Date]) < 90)