2 Replies Latest reply: Aug 22, 2017 11:53 AM by Gysbert Wassenaar RSS

    How can I reverse the sign on QlikView ?

    Oliver Zimmermann

      How can I reverse the sign on QlikView?

       

      Hello everybody,

      I've been using QlikView for about 4 weeks now and I'm getting it right

      Nevertheless, I need your help ..

      In my ERP system, the outgoing invoices are filled with transaction types. The formula itself works, however the occupancy type 'G' must be displayed as minus amount.

      sum (

           {<

           Record Type = { 'R', 'G', 'O'},

      Flag_Artikelfamilie_vorhanden = {1}

           >}

           rangesum (

      #Sales,

      -#Value

      )

           )

      At the moment, QlikView adds all sales from the individual occupancy types, so far so good. Type 'G' must be subtracted.

       

      Can you help me?

      Many Thanks