Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

demaina1995
New Contributor II

import double entry table from Excel in Qliksense

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

6 Replies
omarbensalem
Esteemed Contributor

Re: import double entry table from Excel in Qliksense

can you attach the excel file?

Maybe 4 lines of the excel file?

rittermd
Honored Contributor

Re: import double entry table from Excel in Qliksense

Qlik is not going to recognize the label names as actual dates. 

As Omar said an real example of the file would be helpful to see what our options are.

demaina1995
New Contributor II

Re: import double entry table from Excel in Qliksense

Hi,

You can find attached an extract from the file.

Thanks everyone

omarbensalem
Esteemed Contributor

Re: import double entry table from Excel in Qliksense

tab0:

CrossTable (Month,Measure,2) load *;

LOAD

    Programme,

    "Date MAJ",

    "43101",

    "43132",

    "43160"

FROM [lib://age/TCBtoQlikSense.xlsx]

(ooxml, embedded labels, table is Feuil1);

NoConcatenate

load  Programme,

    "Date MAJ",

   date( num#(Month),'MMMM YYYY') as Month,

    Measure;

load * Resident tab0;

Drop table tab0;

result:

Capture.PNG

demaina1995
New Contributor II

Re: import double entry table from Excel in Qliksense

Thank you so much !

omarbensalem
Esteemed Contributor

Re: import double entry table from Excel in Qliksense

if this made the trick. please close the thread by marking the correct answer as correct.

Omar BEN SALEM.