8 Replies Latest reply: Jan 26, 2015 4:28 AM by Beaulieu Mathieu RSS

    Sum force to calculate 0 if no values?

    Beaulieu Mathieu

      Hi,

       

      I am bloked.

      I want to do a sum of values in table with an expression.

      My problem is that i want to format all results on a same mask (always show all Years even if sum result is 0) .

       

      For exemple the result that i want :

      PartsYearsSum result
      Part 120153
      Part 120140
      Part 120132
      Part 220152
      Part 220143
      Part 220130

      And the exemple of datas :

      PartsDateVal
      Part107/01/20131
      Part112/08/20131
      Part206/06/20141
      Part220/09/20141
      Part224/11/20141
      Part 102/01/20151
      Part 104/01/20151
      Part 121/01/20151
      Part205/01/20151
      Part209/01/2015

      1

       

      My problem is that for Part1 and Year 2014 i've not entry in the table.

      Is it possible to do that in QlikView?

       

      Thanx