10 Replies Latest reply: May 14, 2012 10:38 AM by edwardgovan RSS

    Graph not displaying null values.  Please help!

      I am relatively new to QlikView but I have been spending a considerable amount of time unsucessfully trying to solve the following issue:

       

      I have a database of financial reporting information.  For some months there is no data whatsoever for a project, but I need to be able to see this visually. When I create a graph, it does not display the missing data as being zero! This is a serious problem.  How can I make the chart display zero for the particular month for which there is no data?

       

      As you can see in the following graph (which i have also attached), I have selected a project and you can see in the MonthMaster table that there is no data for March.  But the graph just skips over the month as if it doesn't exist!

       

      QlikView_Dates.png

       

      Thank you in advance to anyone who has any suggestions!