2 Replies Latest reply: Dec 14, 2016 10:34 AM by Vijayanth radha RSS

    Selecting certain records while LOADing in QlikSense

    Vijayanth radha

      What is the syntax for restricting rows while loading data using Data Load editor.

       

      For example I want to load "Color" column where the values are ONLY red and green

       

      Load

      Color as "System Color"

      Quantity

      From  "File"

      where color in ('Red', 'Green')

       

      How to do this?