Discussion board where members can get started with Qlik Sense.
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
Interval(CurrentDate - PreviousDate, 'hh')
For you example:
=Interval(Timestamp#('1/30/2016 12:30:30 PM', 'M/D/YYYY h:mm:ss TT') - Timestamp#('1/30/2016 10:30:23 AM', 'M/D/YYYY h:mm:ss TT'), 'h')
Both are same Field
1/30/2016 10:30:23 am - 0 hh(ouput)
1/30/2016 12:30:30 pm- 2 hh(output)
1/30/2016 15:30:30 pm - 3 hh(output)
Where are you trying to do this? Script or chart?
You can use Peek() or Previous() ?
Interval(DateTime - Previous(DateTime), 'hh')
Not working in my Case
Would you please help on Chart
Would you be able to provide few rows of data of how your data looks like?