topic How to show the date in expression? in QlikView

How to show the date in expression?

Thu, 05 Nov 2015 05:17:20 GMT

Hi to all,

This is hitu,

i need help from one of you, in gantt chart expressions showing minus values. but i wanted to shoewthe hour format like 00:00 to 24:00

Please help on this asap.im attaching sample file also.

thanks

hitu

Anonymous — Thu, 05 Nov 2015 11:51:05 GMT

You can go to number format and then as per your requirement.

Else you can use Time()/TimeStamp() function for same

Anonymous — Thu, 05 Nov 2015 11:51:39 GMT

there is no data and no datamodel in your app

please provide at least with sample data

Thu, 05 Nov 2015 11:57:13 GMT

Try this in your loadstatement

Date,
Year(Date)as Year,
Month(Date) as Month,
Day(Date) as Day,

Hour(Date) As Hour,
Minute(Date) As Minute ;

This convertsa date string 2008-09-01 10 13:23 to correct formats