9 Replies Latest reply: Oct 19, 2016 5:36 PM by Nina Iren Jensen RSS

    How to combine field values from two fields and then select specific values

    Nina Iren Jensen

      Hi :-)

       

      I have two tables - Code1 and Code2.

      I have made a Filter Pane with Code1 as dimension and I want to show only higlighted blue codes from table Code1 and Code2 in the filter pane for Code1.

      Whenever code XX appears in table Code1 it shall be replaced with Code2, but not all - only specific codes are to be shown in Code1.


      I have managed to get XX replaced in Code1 with (not sure if this is the correct way to do it, but the codes were replaced).


      if(code1='XX', [code2], code1)


      But from here I am not able to find the right expression as I am not too familiar with expressions or set analyse.


      Code1Code2
      ABDE
      ABDF
      ADAB
      CDAC
      XXAB
      XXAB
      XXCD

       

      Wanted result in Filter Pane for Code1

      Code1
      AB
      AB
      AD
      AB
      AB

      I am using Qlik Sense Server, v3.x