Discussion board where members can learn more about Qlik Sense App Development and Usage.
I four columns in a Table. LIke
StartDate, StartTime, EndDate, EndTime
30/09/2018, 22:10:55, 01/10/2018, 00:55:23
01/09/2018, 15:10:55, 02/10/2018, 01:55:23
01/09/2018, 22:10:55, 02/10/2018, 15:55:23
03/09/2018, 15:10:55, 03/10/2018, 22:55:23
I want total journey in Minutes.
Subtract the start date and time from the end date and time: EndDate+EndTime-StartDate-StartTime
Perhaps when you load the data you have to change text values into date and time values:
Interval(EndDate+EndTime-StartDate-StartTime,'mm') as JourneyInMinutes
LOAD Date(Date#(StartDate,'DD/MM/YYYY'),'DD/MM/YYYY') as StartDate, Time(Time#(StartTime,'hh:mm:ss'),'hh:mm:ss') as StartTime, Date(Date#(EndDate,'DD/MM/YYYY'),'DD/MM/YYYY') as EndDate, Time(Time#(EndTime,'hh:mm:ss'),'hh:mm:ss') as EndTime, FROM ...source...
That you don't see AM and PM does not mean that the values are numeric values. If I type 25 in this post it is text and not numeric. But if you're sure that they're numbers then I can't help unless you post a small Qlik Sense app with example data that exhibits the problem you describe. So, please post such an example .qvf file.