Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How can we write a script like Set analysis for below scenario?

Hi all ,

I have a issue.

I have two table like

1. StartTime 

2. EndTime

Capture13.PNGCapture12.PNG

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.

Regards,

Kabilan K.

1 Reply

Re: How can we write a script like Set analysis for below scenario?

HI

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

Community Browser