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