6 Replies Latest reply: Dec 4, 2017 3:32 PM by omar bensalem RSS

    import double entry table from Excel in Qliksense

    Caroline Huet



      I have my data in Excel in a double entry table like the one shown below :


      Product typeDate of the cadence updateJanuary 2018February 2018March 2018
      Product 101/01/2017666
      Product 101/02/2017555

      Product 2

      Product 201/02/2017101515


      This represent the history of the change of cadence for different products.


      I would like to import those data in qlik sense in order to calculate revenue.


      I don't manage to have the name of my fields regonizes as a date and the values of that field reconize as number...


      Do you have an idea to import those data ?