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.
hagar333
Contributor

Mapping an IntervalMatch Help Please!

Hi All,
I need to bounce this off a fresh set of eyes!

1) First issue is the EndDate keeps reverting to a Num Date why?

2) I have a Script which is using Interval Match with Extended Syntax and mapping

CostTable with Start, End Dates and NewCosts and a Salestable with a InvDate.

I had to use Previous and order by to clean up the EndDate but you will see in example.

When I trying to Map the NewCost price field it seems I can only get the Lowest or Highest dates to Map.

I have attached an Example Qvd File 
the Orange Colored table has a SalesCost field at end of table
also I have created a Straight table 'Green' with a expression to calc NewCost*Qty field which works?

I have missed something in my script?

any help appreciated
regards Peter

1 Solution

Accepted Solutions
vijay_iitkgp
Valued Contributor

Re: Mapping an IntervalMatch Help Please!

Hi ,

I have updated the script. Please reload and see the result

5 Replies
vijay_iitkgp
Valued Contributor

Mapping an IntervalMatch Help Please!

Hi,

I am unable to open your file. Can you please attach the script in notepad.

hagar333
Contributor

Re: Mapping an IntervalMatch Help Please!

I have upload Script thanks Vijay

vijay_iitkgp
Valued Contributor

Re: Mapping an IntervalMatch Help Please!

Hi ,

I have updated the script. Please reload and see the result

hagar333
Contributor

Re: Mapping an IntervalMatch Help Please!

Hi Vijay,

You are a Champion!

After a bit of testing and looking at your script all looks good, I have learnt a few things

Thankyou very much!

best regards Peter

Not applicable

Mapping an IntervalMatch Help Please!

Hello,

I've a table with Project Nos., StartdateProject,EnddateProject & Revenue

I need to a create a Calender so that on selecting a particular Year , all the projects starting or ending in this Year are displayed.

Moreover, on selecting the Quarters (Q1 or Q2 or Q3 or Q4) the Revenue should be shown only for that Quarter.

For eg. if a project has Yearly Revenue of 1000 & the project runs from 1 Jan, 2015 to 31 Dec, 2015

then on Selecting Q1, Revenue displayed should be 1000/4(=250).

Please help

Regards

Community Browser