Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pujapushkar
Contributor
Contributor

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)