import double entry table from Excel in Qliksense

[Anonymous]

Hi,

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

Product type	Date of the cadence update	January 2018	February 2018	March 2018
Product 1	01/01/2017	6	6	6
Product 1	01/02/2017	5	5	5
Product 2	01/01/2017	10	11	11
Product 2	01/02/2017	10	15	15

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

[OmarBenSalem]

can you attach the excel file?

Maybe 4 lines of the excel file?

[rittermd]

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.

[Anonymous]

Hi,

You can find attached an extract from the file.

Thanks everyone

[OmarBenSalem]

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:

[Anonymous]

Thank you so much !

[OmarBenSalem]

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

Omar BEN SALEM.