Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Data Load with Dates as column fields

I am trying to load data that has a month as a column field and get these results, not sure what is needed to get desired results of excel sample shown



Labels (1)
2 Replies
Contributor II
Contributor II


As a reminder, Qlik interpret dates (coming from your Excel file) like numerical values! So, you need to convert  your headers (directly in your Excel file) into text.  It's simple, just add a single quote at the start for each text (inside each cell).



Hi @MPH ,
I had a similar problem were I was not able to modify the column names to date format 
For values inside fields its possible to use date() function to format them as data , but I didn't find a solution to do so for column headers. 
We can manually rename them in data manager window , if its a one time thing