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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
MVP
MVP

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
MVP
MVP

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