Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Date headed Column in numeric not in text?

Hello All,

I have Excel file which is having multiple columns but I have columns as month also like apr-16 may-16 as below

issue 2.PNG

But when I am loading this excel in Qliksense it is showing like this

issue numeric.PNG

Any type of help in this please.

Regards,

Sid

6 Replies
Highlighted
Specialist III
Specialist III

Hello Sid,

It seems that the field is getting converted as number. Please use given sample expression/field in edit script.

Date(Date#(DateField, 'MMM-YY'), 'MMM-YY') AS DateField

Hope this will be helpful.

Regards!

Rahul

Highlighted
Not applicable

Hello Rahul,

Those Month fields are columns not in Date row so basically this wont help.

Thanks for the reply through.

Highlighted
Creator III
Creator III

Hello Sid,

Change the coulmn headers format to "Text" on excel and try to load it again

Highlighted
Not applicable

Hello Kaan,

I just tried it the columns turned to number after selecting text.

Anything else now I could do cause this is not helping.

Highlighted
Creator III
Creator III

Can you share your excel data file?

Highlighted
Specialist III
Specialist III

Hello Sid,

Could you please share the application with sample data? This will help us to provide you expected feedback.

Regards!

Rahul