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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
10 Replies
Not applicable
Author

Thanks

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