Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Time duration in IF statement

I am trying to create an IF statement in my load script that will identify whether a duration between two timestamps exceeded 45 minutes.

What I have tried is:

(resolved_at - "Opened time") * 24 as 'duration',

If('duration' <= 0.75, 'Met', 'Not Met') as 'SLA',

I have created a table and 'duration' correctly gives the number of hours (in decimal format) between the two timestamps. However, every entry has 'Not Met' in the 'SLA' field.

Clearly there is something incorrect with my number formatting. Any help would be greatly appreciated.

Conor

Tags (2)
1 Solution

Accepted Solutions

Re: Time duration in IF statement

Can you check this:

(resolved_at - "Opened time") as duration,

If(duration <= MakeTime(0, 45), 'Met', 'Not Met') as SLA

1 Reply

Re: Time duration in IF statement

Can you check this:

(resolved_at - "Opened time") as duration,

If(duration <= MakeTime(0, 45), 'Met', 'Not Met') as SLA

Community Browser