Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vinay_bangari
Specialist III
Specialist III

Interval match help

Hi All i have below requirement that For Each Item i have a regular capacity for begin effective date in the Dates table. Some times the Capacity will change for the same Item Number based on the Begin Effective date in the Dates table. Now i have a Fact table with Stock plan date for each Item Number. Here BGN_EFF_DATE and [Stock Plan Date] are not the same dates. But i want the BGN_EFF_DATE to be in the interval range of Stock plan date for each Item No . This will give me a way to combine my Capacity to that of Available Qty for given time period and Item No. Please see below  attached QVW file.

Massimo GrossiApp Development If you have few minutes please help on this.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

7 Replies
MK_QSL
MVP
MVP

Kindly provide sample file in excel along with your required result.

vinay_bangari
Specialist III
Specialist III
Author

HI Manish, The data is present in the QVW file which i attached above Let me put the output result in the excel sheet and send you in few mins.

vinay_bangari
Specialist III
Specialist III
Author

Hi Manish, Output columns are highlighted in yellow please let me know if that helps

vinay_bangari
Specialist III
Specialist III
Author

any help...

vinay_bangari
Specialist III
Specialist III
Author

Any help .. please

maxgro
MVP
MVP

vinay_bangari
Specialist III
Specialist III
Author

Hi Massimo, Thanks a lot for your help.That document helps me a lot. The solution is very good. but only problem i have is the number of records in the table are bumping from 3 millions to 40 millions . Is that expected.