Discussion Board for collaboration on QlikView Scripting.
Facing issue with the time. Need to generate the start time based on the end time and duration.
Go to Solution.
See attached qvw
EndTime - Duration should give you the start time, 21:00:00 (or 09:00:00 PM) in your case, not 09:20:00. Make sure you work with dates and times, not strings. Use the date# and time# functions if necessary to create dates and times from strings.
Interval(time(endtime,'hh:mm:ss')-Time(Duration,'hh:mm:ss'),'hh:mm:ss') as Start_Time
= interval (Time(Time#('12:20:00','hh:mm:ss')) - interval(Time(Time#('3:20:00','hh:mm:ss'))-Time(Time#('0:20:00','hh:mm:ss')),'hh:mm:ss'),'hh:mm:ss')
Bold - Specify hr's format. If you use 12hr Format Specify 12, else 24.
Hope this helps
Thanks Gisbert I have rectified the output value.
Its not giving the desired results.
I can't catch up your logic. I have added the sample data in the Excel with columns EndTime and Duration. Can you please help to achieve StartTime.
Please find the attachment.
Copy the expression and put inside the text object, you will see what your
I have already verified that.Can't get the expected values.
Can you please help ...