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|
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 ?
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.
CrossTable (Month,Measure,2) load *;
(ooxml, embedded labels, table is Feuil1);
date( num#(Month),'MMMM YYYY') as Month,
load * Resident tab0;
Drop table tab0;