9 Replies Latest reply: Aug 8, 2013 10:50 AM by Jonathan Brough RSS

    Missing data

      Hi Guys,


      I am sure this has already been posted,


      can anyone point me in the right direction.


      i have a data table with missing values for set catergories


      Header 1Header 2day 1 day2 day 3day 4


      catergory 1
      1 week1234
      2 weeks2468
      3 weeks36810
      Catergory 21 week1234
      3 week36810


      Currently i have the above,


      i would like qlikview to generate the data to insert 2 weeks into catergory 2 with 0 value so that every catergory has a full set of week ranges 1-3 even if 0


      Hope this is clear


      Many thanks