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

       

       

      Load

      ..

      ...

      ......

      ...........

       

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

      Where

      [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)

      ;