topic Re: Time Interval Help in QlikView

Time Interval Help

abhaysingh — Tue, 29 Sep 2015 07:03:24 GMT

Hey Guyz, Please Help on Below Requirement

Regards

Abhay

Re: Time Interval Help

marcus_sommer — Tue, 29 Sep 2015 13:18:48 GMT

I recommend very strongly to split per floor() and frac() the timestamp into dates and times to connect them by using master-calendar and master-time-table in which beside hours, minutes and seconds also other date/time-cluster could be made. With functions like makedate() and maketime() could be each wanted combination displayed.

How to use - Master-Calendar and Date-Values

- Marcus

Re: Time Interval Help

abhaysingh — Wed, 30 Sep 2015 05:30:56 GMT

Sory marcus, not getting the way you are suggesting, Do you have some sample for the same..please provide.

thanks

abhay

Re: Time Interval Help

sujeetsingh — Wed, 30 Sep 2015 06:21:04 GMT

Follow mark and try implementing the same

Re: Time Interval Help

PrashantSangle — Wed, 30 Sep 2015 06:30:44 GMT

Hi,

try below in your script

Timestamp(Date#(Date,'DD.MM.YYYY hh:mm:ss'),'DD/MM/YYYY hh:00:00 TT')

Regards

Re: Time Interval Help

jonathandienst — Wed, 30 Sep 2015 06:51:48 GMT

This is a duplicate posting - see my answer (which shows how to split date and time portions) on the original posting:

Time Interval Help

Re: Time Interval Help

marcus_sommer — Wed, 30 Sep 2015 07:33:18 GMT

In my answer above is a link which provides various explanations and examples how to create and use such master-structures which then could be used as templates for many of your applications. Therefore you will need to take the efforts to explore them carefully to gain a better understanding how dates and times work and because dates and times topics are related to nearly each reporting-approach it's basic skills which a developer at least up to middle level will need.

- Marcus