Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vinay_bangari
Valued Contributor 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
MVP
MVP

Re: Interval match help

my idea in the attachment

this can help Generating Missing Data In QlikView

7 Replies
MVP
MVP

Re: Interval match help

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

vinay_bangari
Valued Contributor III

Re: Interval match help

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
Valued Contributor III

Re: Re: Interval match help

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

vinay_bangari
Valued Contributor III

Re: Re: Interval match help

any help...

vinay_bangari
Valued Contributor III

Re: Interval match help

Any help .. please

MVP
MVP

Re: Interval match help

my idea in the attachment

this can help Generating Missing Data In QlikView

vinay_bangari
Valued Contributor III

Re: Re: Interval match help

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.

Community Browser