5 Replies Latest reply: Apr 12, 2016 1:45 PM by Sunny Talwar RSS

    Flag the line that doesn't meet a conditon

    Ron Payne

      Hey fellow Qlikkers,

       

      I got another one today that I'm having a hard time with in the script. I want to flag the below highlighted field with a 1. The reasoning behind it is that the line item only has an 'E' in the last column. I need this for both situations, whether the line item only has an 'E' or a 'Q'. We'll want to toss lines out that have both Es and Qs. The flag of 1 is only needed for those lines that don't have both.

       

      I've attached the excel sheet and a qvw. Thanks a lot! I may have a backup plan if we can't get this one.

       

      falg.PNG