topic Re: Time stamp as Dimension...... in QlikView

Time stamp as Dimension......

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

I have 02 time stamps e.g. Opening Time and Closing Time. in this format 6/23/2016 4:59:00 PM 6/23/2016 6:33:00 PM for the month of JUNE 2016.

Now I want to show in a line chart only Hour & Minutes as values on Data Points for each day separately. What will be the expression for it.

Second i want to show the difference of time between the 2 dates using the same dimension i.e. it should show Total hour and minutes worked each day .

Any suggestion please.

Re: Time stamp as Dimension......

MK_QSL — Mon, 04 Jul 2016 12:41:40 GMT

=Interval(TimeStamp(TimeStamp#('6/23/2016 6:33:00 PM','M/DD/YYYY h:mm:ss TT'))

-TimeStamp(TimeStamp#('6/23/2016 4:59:00 PM','M/DD/YYYY h:mm:ss TT')))

Re: Time stamp as Dimension......

MarcoWedel — Mon, 04 Jul 2016 21:45:19 GMT

Hi,

maybe something like this:

tabOpenCloseTime:
LOAD Timestamp#([Opening  Time],'MM/DD/YYYY  hh:mm:ss TT') as [Opening  Time],
    Timestamp#([Closing Time],'MM/DD/YYYY  hh:mm:ss TT') as [Closing Time]
Inline [
Opening  Time,Closing Time
6/23/2016  4:59:00 PM,6/23/2016  6:33:00 PM
6/24/2016  9:52:00 AM,6/24/2016  10:31:00 PM
6/25/2016  7:49:00 AM,6/25/2016  11:29:00 AM
];

hope this hlps

regards

Marco

Re: Time stamp as Dimension......

300sss300 — Mon, 11 Jul 2016 06:45:58 GMT

Thanks

Re: Time stamp as Dimension......

300sss300 — Mon, 11 Jul 2016 06:46:51 GMT

Thanks Marco !

exactly the same thing I needed.

Re: Time stamp as Dimension......

300sss300 — Mon, 11 Jul 2016 08:30:20 GMT

Its not working when I loaded data from Excel File,

Can you please tell me what changes I have to made when same data is loaded from Excel File.

Regards,