6 Replies Latest reply: Jul 19, 2016 8:48 AM by Christian Wylezol RSS

    supress lines when calculation is zero (0,00)

    Christian Wylezol

      Hi,

       

      I have a problem with a Pivot-Table in Qlikview. I have a calculation (please see below), that calculated correct.

      My issue is, that I only want to display lines in the Report where the result of the calculation (White lines) <> 0,00.

      (green lines are the total) How can I realise this?

       

      This is the calculation of the Field "per"

      sum( {$<book_id={'HGB'},eventmapping={'TRA'}, txnyear={"$(=$(Jahr))"}, txnper = {"$(=$(Periode))"}>} value*eventflag)
      -
      sum( {$<book_id={'IFRS'},eventmapping={'TRA'}, txnyear={"$(=$(Jahr))"}, txnper = {"$(=$(Periode))"}>} value*eventflag)

       

      I tried several things, but nothing works.

      It seems to be complicated to supress lines depending on the Expression.

       

      I hope someone have a good idea

       

      Thanks in advance

      Chris