Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum by Year

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

1 Solution

Accepted Solutions
ramkrishna86
Creator II
Creator II

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

View solution in original post

3 Replies
dwforest
Specialist II
Specialist II

use Set Analysis

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

balabhaskarqlik

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
Creator II
Creator II

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