Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this:
=Sum({<[acv extended price] = {'>0'}>}[acv extended price]) or
=Sum(If([acv extended price] > 0, [acv extended price], 0))
May be this:
=Sum({<[acv extended price] = {'>0'}>}[acv extended price]) or
=Sum(If([acv extended price] > 0, [acv extended price], 0))
thank you very much! Makes sense and worked great!
Awesome
I am glad I was able to help