topic Re: Look up time values and return proper item in QlikView

Look up time values and return proper item

Martijn_W — Sat, 16 Nov 2024 19:47:57 GMT

Hello everyone,

I wouldn't normally ask a question like this but I've nearly cracked my head open trying to solve this with still limited knowledge of Qlikview functions/syntax.

What I'm trying to accomplish is the following:

I have an internal system that records all calls and I have an Invoice from a telephone company that has the costs of these calls. I need to know how much each indivdual phone call costs. To figure this out, I need to find a way for Qlikview to evaluate this information to come up with a unambiguous answer.

Can someone please help me?

Kind Regards,

Martijn

Re: Look up time values and return proper item

Stoyan_Terziev — Mon, 28 Oct 2019 16:14:38 GMT

Hi Martijn,

You are looking for the IntervalMatch() function.

You can find an example of this here: https://community.qlik.com/t5/QlikView-App-Development/left-outer-join-help/m-p/1637789#M446950

Keep in mind that since you have time included in your time-related dimension, you need to use TimeStamp() or a date format which includes the hh:mm:ss setting.

I hope this helps!

Kind regards,

Stoyan

Re: Look up time values and return proper item

Brett_Bleess — Tue, 05 Nov 2019 20:08:33 GMT

Martijn, just adding one additional link related to IntervalMatch from the Design Blog area. If Stoyan's post got you what you needed, please be sure to use the Accept as Solution button on his post to give him credit, if you are still trying to sort things, have a look at the following link to see if that may help fill things in a bit further for you and leave an update if you need further help.

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

Regards,
Brett

Re: Look up time values and return proper item

Martijn_W — Wed, 22 Jul 2020 07:47:06 GMT

Sorry for the late response, but this was very helpful, thank you!