topic how to combine these two formulas: in QlikView

how to combine these two formulas:

Thu, 14 Jul 2011 06:33:12 GMT

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.

Re: how to combine these two formulas:

gussfish — Thu, 14 Jul 2011 06:42:20 GMT

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:

Thu, 14 Jul 2011 06:50:27 GMT

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:

Thu, 14 Jul 2011 07:40:53 GMT

Dear Daniel,

you may try thsi exp

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

how to combine these two formulas:

Thu, 14 Jul 2011 14:38:53 GMT

hello yogesh,

thanks for your advice.