Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IntervalMatch() function in a Qlikview application

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

3 Replies
rbecher
Partner - Master III
Partner - Master III

Hi,

I think it's working like designed.

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

intervallmatch.png

- Ralf

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
Not applicable
Author

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

rbecher
Partner - Master III
Partner - Master III

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

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine