topic Within 24 Hours Flag in QlikView

Within 24 Hours Flag

prees959 — Wed, 25 Oct 2017 09:39:33 GMT

HI,

Im trying to set a flag to filter the document to Within 24 hours.

My expression is : if(hours_lead_time>=0 and hours_lead_time<=24,1,0)

However when I filter on this flag within the document it shows hours above 24 hours.

The expression to create hours_lead_time is interval(start_datetime-requested_on,'h')

Can anyone advise on this please?

Thanks,

Phil

tresB — Wed, 25 Oct 2017 09:53:42 GMT

If you see hour is 1, it is actually 1/24 at the back end. Hence try like:

if(hours_lead_time>=0 and hours_lead_time<=1,1,0)

prees959 — Fri, 03 Nov 2017 17:45:14 GMT

HI This has worked - but I cant understand why... Can you explain ?

Many thanks,

Phil