Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Interval Match Problem

Hi All

i have a requirement to get results from two tables through interval match function. Below are two sample tables

1. 

DateBrandValue
5/27/2019AC100
7/15/2019AC80
1/4/2019AC100
8/4/2019AC100
4/15/2019AC100
4/22/2019AC100
4/29/2019AC100
5/6/2019AC100
5/13/2019AC100
5/20/2019AC100
3/6/2019AC100
10/6/2019AC100
6/17/2019AC100
6/24/2019AC100
1/7/2019AC100
8/7/2019AC100
7/22/2019AC100
7/29/2019AC100
5/8/2019AC100
12/8/2019AC100
8/19/2019AC0
8/26/2019AC0

 

2. 

SENDERSub Brand NameAmountStart DateEnd Date
ACA10006/1/201812/31/2099
ACB2006/1/201812/31/2099
ACC3006/1/201812/31/2099
ACD40006/1/201812/31/2099
ACE50006/1/201812/31/2099
ACF60006/1/201812/31/2099
ACG70006/1/201812/31/2099

 

Based on interval match i need to get Brand wise Amount for a particular date that lies in start date and end date

Thanks

Kushal

Labels (1)
2 Replies
Highlighted

Hi Kushal, intervalmatch is used when there are diferent date ranges to apply values, in this case all rows from table 2 has the same dates, maybe you only need a join to have all values from table 1 splitted into all values from table 2 (where Table1.Brand=Table2.SENDER)

Highlighted
Digital Support
Digital Support

Kushal, likely going to need QVW file on this one in order to get some further comments, as folks likely want to see your data model etc. as well in order to try to see exactly how you are doing things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.