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

    Load table twice and union all after difference filtering


      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’


      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