topic Re: Sum by Year in App Development

Sum by Year

Anonymous — Fri, 20 Jul 2018 09:27:39 GMT

I want to show sum by all year and doesn't change on user selection

dwforest — Fri, 20 Jul 2018 20:38:55 GMT

use Set Analysis

Sum({1<Year={'2018'}>} Amount)

BalaBhaskar_Qlik — Sat, 21 Jul 2018 10:56:23 GMT

On Irrespective of Selection:

=Sum({1<Year = {'2018'}>}Sales)

On excluding current selections:

=Sum({1-$<Year = {'2018'}>}Sales)

on all years:

=Sum({<Year = >}Sales).

ramkrishna86 — Mon, 23 Jul 2018 06:01:09 GMT

Sum({1<Year={$(=Year)}>}Sales)