Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have csv file with format date like 1/2/2012 15:27
Qlikview recognises it like text.
I used load script
date(date#(created_at,'YYYY-MM-DD')) as creationdate1,
It didn't work.
Who knows what should to do?
Thanks,
date(timestamp#(created_at, 'D/M/YYYY hh:mm'), 'YYYY-MM-DD')
The timestamp#() tells QV how the date is formatted in the .csv.
The date() tells QV how you want it formatted.
date(timestamp#(created_at, 'D/M/YYYY hh:mm'), 'YYYY-MM-DD')
The timestamp#() tells QV how the date is formatted in the .csv.
The date() tells QV how you want it formatted.
Hi use this
You need to specify the same date format that has in csv file..
date(date#(created_at,'M/D/YYYY'),'MM/DD/YYYY')
Hello again,
I need to calculate week.
I tried to use as you suggested
dual(WeekStart(date(timestamp#(created_at, 'D/M/YYYY hh:mm'), 'YYYY-MM-DD'))& '-' &WeekEnd(date(timestamp#(created_at, 'D/M/YYYY hh:mm'), 'YYYY-MM-DD')),
WeekStart(date(timestamp#(created_at, 'D/M/YYYY hh:mm'), 'YYYY-MM-DD')))as WEEK
but it doesn't recognize like date
What's wrong this dual function?
Thanks
Any ideas?
Whwn you say you need to calculate Week is it a date field or a numeric field
Do you want to calculate Sales this week or just add the week number using the date
to add the WeekNumber try,
if you want to calculate Sales this week it would be like this
In csv file: my field created_at looks like 04/09/2011 6:47:00 PM. When I open it in excel, format cell is custom.
Excel thinks it text field, because it suggests to sort from A or Z.
I need to see first day and last day of the week and also I need sort it by asc or desc.
Thanks,
Sorry, but it didn't work. It recodes only untill 4/12/2013 -> 2013-12-04.
I don't know why?
Maybe I need to change somewhere settings for date format?
Try this video I made on YouTube that may help