topic IntervalMatch() function in a Qlikview application in QlikView

IntervalMatch() function in a Qlikview application

Fri, 06 May 2011 15:24:52 GMT

Hi community.

Here is the application that I developed in QlikView.

In the script, I use the IntervalMatch() function .

But my results are not those expected.

Help me solve the problem, please it is urgent.

Thanks

IntervalMatch() function in a Qlikview application

rbecher — Fri, 06 May 2011 18:16:09 GMT

Hi,

I think it's working like designed.

DEBCPTE - FINCPTE is the intervall where IDKEY get matched. But maybe you're want something different...

- Ralf

IntervalMatch() function in a Qlikview application

Fri, 06 May 2011 18:29:52 GMT

Please sir RALF, can you change the expression of IDKEY in Left(NUMCPT, 8), and see the result.

Do the same for the fields DEBCPTE and FINCPTE.

Thanks

IntervalMatch() function in a Qlikview application

rbecher — Fri, 06 May 2011 18:55:02 GMT

You should follow Oleg's proposal in this thread: http://community.qlik.com/message/114222#114222