6 Replies Latest reply: Nov 24, 2017 12:37 PM by Antonio Mancini RSS

    Expand Date Range with Values

    Hannes Peiffer

      Hi Qlikers,


      I have a similar problem as discussed in How to expand dates with values. | Qlik Community, but slightly different. I also have tried to adjust the program code to my needs, but with no success.


      What I have as base is the Excel file attached. I have Customer, Parts, a Valid_Date and the Price (Rows A-D)


      What I want to achieve is shown in Row F (desired Result). I want to expand the Parts per Customer with the Price that lays between the two dates on a daily basis.


      I have marked the "transition" per Customer/Part/Date regarding the two prices.


      Maybe anyone can help me.