6 Replies Latest reply: Sep 5, 2018 10:10 AM by Gabor Tarnoczai RSS

    Include values in list...?

    Raman Singh

      Hi All,


      I am trying to create a column which can then be used as an expression in a table. Below is what I would like but I am not sure how this is written.


      Data Load Editor




          IF(type= Match(type,'ZBC','XQC','XQH'),1,0) as TypeFlag

      FROM [lib://L1-Tracking.qvd]



      Sum({<TypeFlag= {1}>}TypeFlag)


      This will then filter my table for only the above-listed types.


      Thank you in advance.