Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
But when I am loading this excel in Qliksense it is showing like this
Any type of help in this please.
Regards,
Sid
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
Hello Rahul,
Those Month fields are columns not in Date row so basically this wont help.
Thanks for the reply through.
Hello Sid,
Change the coulmn headers format to "Text" on excel and try to load it again
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.
Can you share your excel data file?
Hello Sid,
Could you please share the application with sample data? This will help us to provide you expected feedback.
Regards!
Rahul