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

    import double entry table from Excel in Qliksense

    Caroline Huet

      Hi,

       

      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

      01/01/2017101111
      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 ?

       

      Thanks,

       

      Caroline