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!




      Thank you in advance to anyone who has any suggestions!