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

# 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".

• ###### Re: how to combine these two formulas:

Can you explain what you mean by "combine"?  This simplest way to combine then is to add them together using '+', but I suspect that isn't what you mean...

• ###### Re: how to combine these two formulas:

hi,

perhaps it's easier to explain it verbally.

i want to sum the amount of rectractions of an (in a Listbox selected) store, without selecting "rectracion" in the Listbox "TypeOfVoucher".

i hope the issue is now a little bit more  unterstandable.

• ###### how to combine these two formulas:

Dear Daniel,

you may try thsi exp

=Sum( {<TypeOfVoucher={ 'rectraction' },store= >} amount)

• ###### how to combine these two formulas:

hello yogesh,