4 Replies Latest reply: May 11, 2016 7:04 PM by Jose Antonio Garcia RSS

    I'm having trouble using a variable!

    Jose Antonio Garcia

      Hi! I'm new in Qlik Sense, I've been trying to do the following but I can't.


      The date and date of cancellation is composed by YEAR-CAMPAIGN (YYYYCC)

       

      The date of cancellation is registered on the date of the order (date) like the following

       

      DATEDATE OF CANCELLATIONORDERS
      2015172015186,029.00
      2015182015193,211.00
      2015192015203,370.00
      2015202015214,513.00
      2015212015224,094.00

       

       

      but I need to do this:

         

      DATEDATE OF CANCELLATIONORDERS
      201517
      2015182015186,029.00
      2015192015193,211.00
      2015202015203,370.00
      201521201521

      4,513.00

       

      I've been trying somethin like this:

       

      DATE_OF_CANCELATION={#(=DATE)}

       

      But is not working, could you please help me?