12 Replies Latest reply: Feb 12, 2016 5:25 PM by patrico mesri RSS

    Insert Field when equal to other column multiple values

    patrico mesri

      Hi Qlik Community.

      I'm here today with what must be a really easy task.

      I need to insert a Field but only when is equal to other column values.

      Here is my table:

       

         

      NombreCategoría
      Manuel AndresJPE
      María del MarJPE
      Gabriela SusanaSupervisor
      GustavoDirector
      ChristianSenior
      Damian UrielJP
      RamonGerente
      HernanGerente
      Leandro MartinSenior
      Carlos MatiasSenior

       

      I want to insert in my table in Qlik Sense the Column "Nombre" when "Categoría" is equal to JP, JPE and Senior.

      I bet this has to be like the easiest thing in Qlik but I can't figure out how to do it.

       

      Thank you in advance.

      Regards.