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.

       

      Best,

      Hannes