Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

expression to pull avg acv greater than zero

Hi guys,

fairly new to the qlik community trying to figure out an expression to pull our field 'acv extended price' when it's greater than zero. Any thoughts?

1 Solution

Accepted Solutions

Re: expression to pull avg acv greater than zero

May be this:

=Sum({<[acv extended price] = {'>0'}>}[acv extended price]) or

=Sum(If([acv extended price] > 0, [acv extended price], 0))

3 Replies

Re: expression to pull avg acv greater than zero

May be this:

=Sum({<[acv extended price] = {'>0'}>}[acv extended price]) or

=Sum(If([acv extended price] > 0, [acv extended price], 0))

Not applicable

Re: expression to pull avg acv greater than zero

thank you very much! Makes sense and worked great!

Re: expression to pull avg acv greater than zero

Awesome

I am glad I was able to help

Community Browser