topic Mapping an IntervalMatch Help Please! in QlikView https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336561#M704868 <HTML><HEAD></HEAD><BODY><P>Hi All,<BR />I need to bounce this off a fresh set of eyes! </P><P></P><P>1) First issue is the EndDate keeps reverting to a Num Date why?</P><P></P><P>2) I have a Script which is using Interval Match with Extended Syntax and mapping </P><P>CostTable with Start, End Dates and NewCosts and a Salestable with a InvDate. </P><P></P><P>I had to use Previous and order by to clean up the EndDate but you will see in example.</P><P></P><P>When I trying to Map the NewCost price field it seems I can only get the Lowest or Highest dates to Map.</P><P></P><P>I have attached an Example Qvd File&nbsp; <BR />the Orange Colored table has a SalesCost field at end of table <BR />also I have created a Straight table 'Green' with a expression to calc NewCost*Qty field which works?</P><P></P><P>I have missed something in my script? </P><P>any help appreciated <BR />regards Peter</P></BODY></HTML> Wed, 04 Apr 2012 06:41:08 GMT Peter_Brunner 2012-04-04T06:41:08Z Mapping an IntervalMatch Help Please! https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336561#M704868 <HTML><HEAD></HEAD><BODY><P>Hi All,<BR />I need to bounce this off a fresh set of eyes! </P><P></P><P>1) First issue is the EndDate keeps reverting to a Num Date why?</P><P></P><P>2) I have a Script which is using Interval Match with Extended Syntax and mapping </P><P>CostTable with Start, End Dates and NewCosts and a Salestable with a InvDate. </P><P></P><P>I had to use Previous and order by to clean up the EndDate but you will see in example.</P><P></P><P>When I trying to Map the NewCost price field it seems I can only get the Lowest or Highest dates to Map.</P><P></P><P>I have attached an Example Qvd File&nbsp; <BR />the Orange Colored table has a SalesCost field at end of table <BR />also I have created a Straight table 'Green' with a expression to calc NewCost*Qty field which works?</P><P></P><P>I have missed something in my script? </P><P>any help appreciated <BR />regards Peter</P></BODY></HTML> Wed, 04 Apr 2012 06:41:08 GMT https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336561#M704868 Peter_Brunner 2012-04-04T06:41:08Z Mapping an IntervalMatch Help Please! https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336562#M704869 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>I am unable to open your file. Can you please attach the script in notepad.</P></BODY></HTML> Wed, 04 Apr 2012 06:52:58 GMT https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336562#M704869 vijay_iitkgp 2012-04-04T06:52:58Z Re: Mapping an IntervalMatch Help Please! https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336563#M704870 <HTML><HEAD></HEAD><BODY><P>I have upload Script thanks Vijay</P></BODY></HTML> Wed, 04 Apr 2012 07:01:40 GMT https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336563#M704870 Peter_Brunner 2012-04-04T07:01:40Z Re: Mapping an IntervalMatch Help Please! https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336564#M704871 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have updated the script. Please reload and see the result</P></BODY></HTML> Wed, 04 Apr 2012 08:52:00 GMT https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336564#M704871 vijay_iitkgp 2012-04-04T08:52:00Z Re: Mapping an IntervalMatch Help Please! https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336565#M704872 <HTML><HEAD></HEAD><BODY><P> Hi Vijay,</P><P>You are a Champion!</P><P>After a bit of testing and looking at your script all looks good, I have learnt a few things </P><P>Thankyou very much!</P><P>best regards Peter</P></BODY></HTML> Wed, 04 Apr 2012 23:41:26 GMT https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336565#M704872 Peter_Brunner 2012-04-04T23:41:26Z Mapping an IntervalMatch Help Please! https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336566#M704873 <HTML><HEAD></HEAD><BODY><P> Hello,</P><P></P><P>I've a table with Project Nos., StartdateProject,EnddateProject &amp; Revenue</P><P>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.</P><P>Moreover, on selecting the Quarters (Q1 or Q2 or Q3 or Q4) the Revenue should be shown only for that Quarter.</P><P></P><P>For eg. if a project has Yearly Revenue of 1000 &amp; the project runs from 1 Jan, 2015 to 31 Dec, 2015</P><P></P><P>then on Selecting Q1, Revenue displayed should be 1000/4(=250).</P><P></P><P>Please help</P><P></P><P>Regards</P></BODY></HTML> Sun, 06 May 2012 12:12:15 GMT https://community.qlik.com/t5/QlikView/Mapping-an-IntervalMatch-Help-Please/m-p/336566#M704873 2012-05-06T12:12:15Z