6 Replies Latest reply: Nov 25, 2013 5:47 AM by Nils Söderström RSS

    Omitting Zeros in Charts

      Hi,

       

      I have a problem trying to define values in a chart in Qlikview. Here's the story:

       

      I have a report that moves from through different stages; received --> pending --> filed. As the report moves from one stage to the next it gets an date stamp when it gets the new status. A filed report will as a result have a received, pending and a filed date. A pending report, on the other hand, will only have a received and a pending date, where the filed date will show up as 0. This is all set in the SAP data base from where I load the data.

       

      Now, the problem is that when i set up a chart for all reports with the status "pending" over a set years, I will get a huge bar at year 0 due to the fact that it will then calculate all the reports with a year 0, that is all reports that has yet to be "filed".

       

      What I would like to do here is to is to include a conditional expression in the chart saying something like:

       

      WHEN

      received_date <> 0 AND

      pending_date <> 0 AND

      filed_date == 0

      INCLUDE VALUE

       

      (mind you here that I dont really know how all the syntaxes work yet )

       

      I just dont know how to do this. I cannot change the way the numbers are loaded into Qlikview - that's just not an option due to internal restrictions. I have been thinking about creating a sort of load table to sort the values, but I cant seem to that right either.

       

      Thanks!