Compare qvw open time to in-line range table

[chrismtb]

This will be an easy one no doubt...

I have an in-line table I am loading into QlikView:

upper_time	lower_time	Exp_Load_Time
04:45	23:45	21:15
08:45	04:45	02:15
12:45	08:45	06:15
16:45	12:45	10:15
20:45	16:45	14:15
23:45	20:45	18:15

The simple task I have is to display via an expression (in a text object) the correct Exp_Load_Time based on the Now() function.

I am using Now(2) for the document open time.

So if the open time was 15:41 I would want to return in the text box 10:15 as this is greater than 12:45 and less than or equal to 16:45

I assume it is set analysis that is needed but despite several attempts I have never been very good at it!

All help appreciated.

Chris

[Anil_Babu_Samineni]

May be this?

=Only({<Exp_Load_Time = {">=12:45 <=16:45"}>} If(Time(Now(2),'hh:mm') = '15:41', '10:15'))

[antoniotiman · Accepted solution]

Hi Chris,

in Text Box

=Only({<Rowno={"$(=Min({<upper_time={'>=$(=Time(Now(1)))'}>} Rowno))"}>} Exp_Load_Time)

My Time is 17:34 (Now(1))

Regards,

Antonio

[chrismtb]

Antonio - works like a charm Thanks!!