Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date format from CSV

Hi community,

I have a problem with a date field (maybe it isn't even processed as a Date field when loaded in Qlik.)

This is the csv view of the field.

qlikcap.JPG

So I am trying to get the Month and Year from this field and I have tried all the following in load script (because the field just doesn't read as a date field.

script.JPG

This is what I see in the dashboard view:

dash.JPG

Lastly, here's the SETTINGS (I have tried a few date formats)

date.JPG

Would greatly appreciate any help! Thank you in advance.

Regards,

Wai Meng

6 Replies
Anonymous
Not applicable
Author

Note in Dashboard view, D and D2 have been sorted numerically.

D sorted by Ascending.

D2 sorted by Descending.

agigliotti
Partner - Champion
Partner - Champion

you can use the below expression in your script:

month(date#([datetime s], 'd-mmm-yy') ) as Month

year(date#([datetime s], 'd-mmm-yy') ) as Year

Anonymous
Not applicable
Author

Hi Andrea,

I tried and nothing shows up. =(

sth_wch004
Contributor III
Contributor III

Hi Wai Meng,

Refer attached. is it what you are looking for?

Capture.PNG

agigliotti
Partner - Champion
Partner - Champion

What you get in Month and Year fields ?

shraddha_g
Partner - Master III
Partner - Master III

Check for the Date field format without using any function.

May be it is in Number Format and you don't have to use Date#()