4 Replies Latest reply: Jul 18, 2015 4:20 PM by Julien CHOLLET RSS

    Concatenate 2 fields (Text and Date)

    Julien CHOLLET

      Hi,

       

      I would like to concatenate 2 fields in Qlik Sense :

      1 field [GAME] which is TEXT format

      1 field [GAME DATE]which is DATE format (DD/MM/YYYY)

       

      I tried in the script to do this :

      [GAME] &' '&text([GAME DATE]) as [GAME AND DATE]

       

      But I doesn't work.

      I get for example FRANCE 41939 instead of FRANCE 27/10/2014.

       

      Do you known how could I get the correct result ?

       

      Thank you for your help

       

      Sincerely