Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Brunner
Creator
Creator

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
Partner - Specialist
Partner - Specialist

Hi ,

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

View solution in original post

5 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

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

Peter_Brunner
Creator
Creator
Author

I have upload Script thanks Vijay

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi ,

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

Peter_Brunner
Creator
Creator
Author

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

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