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.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
MPH
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

MPH_0-1612994879867.png

 

Labels (1)
2 Replies
sbarro1
Contributor II
Contributor II

Hello,

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).

Regards.

AnkitMadhukar
Creator
Creator

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