Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Set analysis (using -= with a YTD indicator)

My Data:

YTDAmount
YTD75
-25

I want to return the null value of YTD which is 25, but I keep getting a " 0 ":

=sum({<YTD-={'YTD'}>} Amount)

Tags (1)
6 Replies

Re: Set analysis (using -= with a YTD indicator)

=SUM({$<YTD = {"=Len(Trim(Replace(YTD,'-','')))=0"}>}Amount)

zagzebski
Contributor

Re: Set analysis (using -= with a YTD indicator)

Thanks for the response, Unfortunately I am still getting a " 0 ".

Any thoughts?

anbu1984
Honored Contributor III

Re: Set analysis (using -= with a YTD indicator)

It's not working because of Null value in YTD. Try this

=sum({1-<YTD={'YTD'}>} Amount)

Re: Set analysis (using -= with a YTD indicator)

Provide your data.... Both My and Anbu's solution should work...

anbu1984
Honored Contributor III

Re: Set analysis (using -= with a YTD indicator)

Or

=sum({<Amount=E({<YTD={'YTD'}>})>} Amount)

MVP
MVP

Re: Set analysis (using -= with a YTD indicator)

set analysis

sum({1-<YTD={"*"}>} Amount)

no sa

sum(if(IsNull(YTD),Amount))

Community Browser