6 Replies Latest reply: Nov 18, 2016 10:29 AM by Wilson Wu RSS

    Load table twice and union all after difference filtering

    Wilson Wu

      Hi

      How can I filter below product table by Series and Family based on User Id?

      In SQL, if “user1” will load Family = ‘F1’ and Series = ‘S3’, I will do

      Select * from Products where Family = ‘F1’

      Union

      Select * from Products where Series = ‘S3’

       

      How can I do this in QlikView script?

       

      Table - Products

      ProductId, Series, Family

      P1, S1, F1

      P2, S2, F1

      P3, S3, F2

      P4, S4, F2

       

       

      Thanks

      Wilson