topic Set analysis (using -= with a YTD indicator) in QlikView

Set analysis (using -= with a YTD indicator)

zagzebski — Sat, 27 Sep 2014 16:47:45 GMT

My Data:

YTD	Amount
YTD	75
-	25

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

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

MK_QSL — Sat, 27 Sep 2014 17:04:21 GMT

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

zagzebski — Sat, 27 Sep 2014 17:11:21 GMT

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

Any thoughts?

anbu1984 — Sat, 27 Sep 2014 17:12:03 GMT

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

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

MK_QSL — Sat, 27 Sep 2014 17:14:50 GMT

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

anbu1984 — Sat, 27 Sep 2014 17:25:18 GMT

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

maxgro — Sat, 27 Sep 2014 18:03:00 GMT

set analysis

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

no sa

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