topic Re: Need help on a formula in QlikView

Need help on a formula

Fri, 20 Nov 2020 18:02:30 GMT

In my formula below, I'm totaling all the revenues received in prior year that equal transaction code 18.

=sum({$ <Type={'Revenue'}, TC = {"> 18"}, CalYear={$(vPriorYear)}>}[Transaction Amount])

The formula works fine but I need to exclude a certain account number. The field associated to the account number is Acct# and the actual account number is 59901

I am new to qlikview and would appreciate any assistance.

Thanks

Re: Need help on a formula

jaimeaguilar — Fri, 28 Mar 2014 00:30:18 GMT

Hi,

try like this:

=sum({$ <Type={'Revenue'}, TC = {"> 18"}, CalYear={$(vPriorYear)}, Acct# -= {59901}>}[Transaction Amount])

sum({$ <Type={'Revenue'}, TC = {"> 18"}, CalYear={$(vPriorYear)}, Acct# ={'*'}-{59901}>}[Transaction Amount])

regards

Re: Need help on a formula

Fri, 28 Mar 2014 00:35:00 GMT

Thank you. It worked.