Discussion board where members can get started with QlikView.
Hi all ,
I have a issue.
I have two table like
Here, Now if I select the 2:36:07 AM from Endtime means Possible value for starttime is 2:36:07 AM.
But, I want to like below :
If I select the 2:36:07 AM from Endtime means Possible value for starttime is 2:36:05.
Likewise I need this 2:36:08 -----> 2:36:07.
Thanks In advance.
Try like this
= time(time('2:36:05 AM')-1/(3600*60)) gives 2:36:04 AM
so, try like this time(time(yourField)-1/(3600*60)) as starttime
Hope it helps