Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using Qlikview10.
I have a Date field in my table but it is in string format.
I have to arrange the report By Week. I have an excel sheet where year, week, fdate, ldate fields are there which indicate that which date falls on which week of which year.
But I can't able to understand how to implement this to my report/table.
Please Suggest.
Hi,
I am not able to reload your table but its okay yes as Simmons say you need to join the fields or use @3 as a field to make date use this
Load
Makedate( Left( @3, 4 ), Mid( @3, 5 , 2 ),Right( @3, 2 ) ) as Date
Resident Tab1;
Regards,
Anand
Perfect.
Thanks Simmons and Anand.
Your work is really appreciable.
Anand - do you have any suggestions on how to format a date that looks like this 11912 to be 1/19/2012?
Hi,
Use the following example of Load statement
LOAD
Date,
Year(Date) AS Year,
Month(Date) AS Month,
Day(Date) AS Day
'
'
';
LOAD
Date(Date#(DateField, 'YYYYMMDD')) AS Date
'
'
'
'
FROM ABC.txt;
In the above script you can arrive the Year, Month, Day and Date in valid format. By using Month, Year and Day dimensions you can create the charts.
Hi,
Use Date#()
=Date(Date#(DateFieldName, 'MDDYY'), 'M/DD/YYYY')
Hope this helps you.
Regards,
Jagan.