2 Replies Latest reply: May 28, 2018 1:14 PM by Shivanand Kamath RSS

    Remove defined rows

    Mikael Schmitz

      Hello Qlik friends,


      I have a little questions for you.

      Maybe you know a way how the problem could be solved. I would like to remove rows in a table.

       

       

      YearMonthNoType
      201801FC
      201801BUDGET
      201801ACTUAL
      201802FC
      201802BUDGET
      201802ACTUAL
      201803FC
      201803BUDGET
      201804FC
      201804ACTUAL

       

       

      I would like to remove the rows which contains FC, if the same Year and MonthNo contains ACTUAL.

       

      Hopefully, I could explain my little problem.

      Thank you very much for your support.

       

      Best regards,