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

    Concatenate 2 fields (Text and Date)



      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