topic Re: Expression Interval Date in QlikView

Expression Interval Date

Wed, 04 Sep 2013 11:16:50 GMT

Something is wrong with this expression, but can not figure out. Can you help me?

Only({$<Local={'Vila Recreio','Ponte Preta','Imbariê'},hora={">=$(=hora)<$(=hora + Time('00:40', 'hh:mm'))"}>}hora)

The expression should consider the date is between "hour" and hour + 40 minutes.

example:

My table:

Local	Sentido	Placa	dataHora
Vila Recreio	Rio de Janeiro	LLS0000	10/08/2013 08:30
Ponte Preta	Rio de Janeiro	LLS0000	10/08/2013 08:42
Piabetá	Rio de Janeiro	LLS0000	10/08/2013 11:16
Ponte Preta	Rio de Janeiro	LLS0000	10/08/2013 11:26
Ponte Preta	Rio de Janeiro	LLS0000	10/08/2013 12:59

Table of expression:

Data	Sentido	Placa	Entrada	Saída
10/08/2013	Rio de Janeiro	LLS0000	Piabetá - 11:16	?

Re: Expression Interval Date

vikasmahajan — Wed, 04 Sep 2013 11:19:58 GMT

Hiii

Please Find attachment.

Vikas

Re: Expression Interval Date

Wed, 04 Sep 2013 12:59:20 GMT

Hello! Sorry but I need a solution using Expression. Anyway thanks for listening.

Re: Expression Interval Date

tresB — Wed, 04 Sep 2013 13:16:04 GMT

The issue is with the format i guess. You are trying to add minutes to hours. You have to be careful about the format of the hour field. Working on the below part of your expression should resolve your issue.

hora + Time('00:40', 'hh:mm')

Re: Expression Interval Date

Wed, 04 Sep 2013 13:26:49 GMT

Thank you for your attention, but what is wrong? I can not understand.

Re: Expression Interval Date

tresB — Wed, 04 Sep 2013 13:35:59 GMT

What i wanted to mean is, please check if the output of hora + Time('00:40', 'hh:mm') is of similar format as in hora field or not.

Edit: One more point, you are using Only() function which will return '-' (null) if there is more than one values. Do you really want the output to be so? If not, you might want to use Concat() function instead.