1 Reply Latest reply: Jun 27, 2017 1:29 PM by Anil Babu Samineni RSS

    Filter population based on field selection

    Will Moscoso

      I have a field containing the following information:

       

      Member                         Years

      1                                     2017, 2016, 2015

      2                                     2017, 2015

      3                                     2016, 2015


      When selecting a filter, I want to show the members that were in 2017 AND the members that were also in 2015.  So, in this case, I want to show Member 1 and 2.



      How can I do this with Qlikview. Is there a way I can use my filter to strip out information from my Years Field?

        • Re: Filter population based on field selection
          Anil Babu Samineni

          May be this?

           

          Load Member, SubField(Years) as Years Inline [

          Member        ,                 Years

          1                   ,                  2017, 2016, 2015

          2                    ,                 2017, 2015

          3                     ,                2016, 2015

          ] where Match(SubField(Years),'2015','2017');