topic Hour calculation along with timestamp in QlikView

Hour calculation along with timestamp

Tue, 22 Sep 2009 02:41:37 GMT

I have data looks like

Order	ToDate	FromDate
1001	20090625160000	20090625143000
1002	20090626240000	20090625163000
1003	20090625143000	20090625133000
1004	20090625163000	20090625160000
1005	20090625133000	20090625113000

Todate-From date -I would like to have the result will be in the hour

interval(ToDate-FromDate)*24 as Hours is working .When I have Date along with time is not calculating

I tried Interval#,Floor ,Hour,timestamp# - nothing worked.

timestamp(ToDate-FromDate) as NoofHours

timestamp#

(FromDate& ftime,'DD/MM/YYYY hh:mm:ss') as FDATETIME1,

timestamp#

(ToDate& totime,'DD/MM/YYYY hh:mm:ss') as TODATETIME1,

Thank you in advance for your help.

Hour calculation along with timestamp

Tue, 22 Sep 2009 07:13:42 GMT

I gave this a try, but it seems you can't do any operations between variables created with timestamp# (I tried substracting, using age(), etc) ..hopefully somebody has a better idea.

Hour calculation along with timestamp

Tue, 22 Sep 2009 11:33:53 GMT

Assuming the table data represents your timestamp format. Then the expression should be:

(timestamp#(ToDate,'YYYYMMDDhhmmss')-timestamp#(FromDate,'YYYYMMDDhhmmss'))*24