4 Replies Latest reply: Jul 14, 2011 10:38 AM by daniel_k RSS

    how to combine these two formulas:

       

       

      Hi All,

       

      i'm new to QlikView.

       

      I'm trying to combine the following formulas:

       

      formula 1, looks like this:

      = sum  ( {$} total <store> amount )

       

      this formula should sum the dimension "amount" of a "selected store"

       

      formula 2, looks like this:

      = sum ( {<TypeOfVoucher={ 'rectraction' }>}amount)

       

      this formula shoud sum the dimension "amount" without selecting the "TypeOfVoucher".

       

      Thanks in advance.