4 Replies Latest reply: Aug 12, 2011 7:38 PM by javortiz RSS

    How to fill in missing values in data

    Johan Fredrik Øhman



      I have run into an issue which I thought someone here could answer..


      Date                 Name        Value


      01/01/2011        John          10

      01/01/2011        Peter          22

      02/01/2011        John          11

      *** Missing***

      03/01/2011        John          10

      03/01/2011        Peter          22



      When I select "Peter" and graph this kind of data.  I have to use "Continuous" axis in order to get all dates on the x-axis, but this introduces some visual artifacts.  Instead,  I'm looking for a method to "fill inn" a zero value on each date that misses a name, so that the data "is there", just with a zero value.


      Optimally, this should have been solved in the raw data in the database.  However, I'm not in charge of that, so that leaves me with two options:


      1. Modify the data in the SQL statement

      2. Modify the data in Qlikview Scripting language


      Any suggestions for approaches is greatly appreciated.