4 Replies Latest reply: Sep 28, 2017 9:50 AM by Rasmus Nielsen RSS

    Filling in the missing data

    Rasmus Nielsen

      Hi guys,

       

      I have read:

      How to populate a sparsely populated field

      Generating Missing Data In QlikView

       

      I have an extra dimension "Station" and I struggle to find out how to make the linked articles apply to this problem:

       

      My table looks like:

      StationDatePrice
      A2017-01-011.500
      A2017-01-041.550
      A2017-01-081.488
      B2017-01-031.300
      B2017-01-081.305

       

      And I would like to fill in the missing rows to get the following result:

      StationDatePrice
      A2017-01-011.500
      A2017-01-021.500
      A2017-01-031.500
      A2017-01-041.550
      A2017-01-051.550
      A2017-01-061.550
      A2017-01-071.550
      A2017-01-081.488
      B2017-01-031.300
      B2017-01-041.300
      B2017-01-051.300
      B2017-01-061.300
      B2017-01-071.300
      B2017-01-081.305

       

      So, I want to fill in rows between the original data to have a row for each day. But how?

       

      Thanks!