Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mr_novice
Contributor II

Intervalmatch problem

Hello All!

I have a problem with intervalmatch. I just cant get it to work. I think I have a problem with the Time-field but I dont know how to change it.

Im attaching my testfile.

I hope someone out there can give me som suggestions how to change my code.

Thank you!

Br

cris

Tags (1)
1 Solution

Accepted Solutions

Re: Intervalmatch problem

You'll need to extract the time portion from the timestamp by using frac().

time(frac(DelDate),'hh:mm') as Time

The time() functiom only formats the display value, it does not extract the time only.

-Rob

3 Replies

Re: Intervalmatch problem

You'll need to extract the time portion from the timestamp by using frac().

time(frac(DelDate),'hh:mm') as Time

The time() functiom only formats the display value, it does not extract the time only.

-Rob

mr_novice
Contributor II

Re: Intervalmatch problem

Thank you Rob!

You solved my problem. I didnt think about that. Now there's another problem. I dont get a match with all intervals even though a match should be done. I have a match to only only one row in the 'interval table'. Could it still be a time-format problem?

Br

cristian

Re: Intervalmatch problem

Hard to say. If you could post another example -- without dropping the tables -- I'll take a look.

-Rob

Community Browser