topic Re: YTD Column not affected by current selection in QlikView

YTD Column not affected by current selection

nrwlafhus — Tue, 10 Jan 2017 21:30:45 GMT

Hello Friends,

I have a table that shows cost per month by account. The MTD column shown below is behaving correctly, i.e., it responds to the selections. However, the YTD column is calculating properly, but will show for omitted selections. YTD expression is below. Any help would be most appreciated. Thanks in advance!

=sum( {$<[MonthID] = {"<=$(=max(MonthID))"}>} [Actual])

Re: YTD Column not affected by current selection

sunny_talwar — Tue, 10 Jan 2017 22:40:50 GMT

Two options

=Sum({$<[MonthID] = {"<=$(=max(MonthID))"}>} [Actual]) * Avg(1)

=If(Sum(Actual) > 0, Sum({$<[MonthID] = {"<=$(=max(MonthID))"}>} [Actual]))

Re: YTD Column not affected by current selection

johnw — Tue, 10 Jan 2017 22:48:21 GMT

I'm unclear what you mean, but maybe you want this - the intersection of the MonthID selections and your set expression.

sum({<[MonthID]*={"<=$(=max(MonthID))"}>} [Actual])