Re: Time interval - Page 2 - Qlik Community

scotly-victor · ‎2016-09-28

Hi Everyone ,

I have requirements I need get interval between current date and previous date by hour

for example 1/30/2016 10:30:23 am

1/30/2016 12:30:30 pm

my output is 2 hours

Please help me out

sunny_talwar · ‎2016-09-28

These are all within the same hour? What output do you expect to see?

sunny_talwar · ‎2016-09-28

Also are there any other dimension where this needs to reset?

scotly-victor · ‎2016-09-28

No,not same hour

I wanted to show current date and previous date by hour difference

My Output : 2 (hh)

lakshmikandh · ‎2016-09-28

Hi,

Please have a look at these time functions as well.

This will be helpful in future works.

Thanks,

Lakshmikandh