Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

intervalmatch use

Hello guys

I'm trying to find solution with intervalmatch but I think I'm missing something...

I have 2 tables:

   

ClientsByDates
MonthClientKey
02-2013100
03-2013100
04-2013100
02-2013101
03-2013101
04-2013101
02-2013102
03-2013102
04-2013

102

 

   

ClientsLevelels
FromMonthToMonthClientKeyLevel
                        02-201303-2013    1001
04-201307-2013    1004
02-201303-2013     991
04-201307-2013      992

 

As a result I want to get the Client Level from second table in the first one by month:

   

ClientsByDates
MonthClientKeyLevel
02-20131001
03-20131001
04-20131004
02-2013101-
03-2013101-
04-2013101-
02-2013102-
03-2013102-
04-2013102-
992
991

Thanks in advance for your help

10 Replies
Not applicable
Author

Thanks

I decided not to present client99 (thanks to you) and your solution works great