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: 
asmithids
Partner - Creator II
Partner - Creator II

Set Analysis - Annual Sum

Hello,

I am trying to sum sales for a year based on the Year list box using the following expression. 

sum({$<Year = {$(=max(Year))}>} (MainAmount)) 

The issue is I am losing the annual sales sum when I select a month from the Month list box.  Other than the Year list box, I don't want any other time dimension to effect summing for the year.

Thank you in advance for any help with this issue.

1 Solution

Accepted Solutions
chiru_thota
Specialist
Specialist

You ignore Month and other dimensions from the expression.


sum({$<Month=,Date=,Year = {$(=max(Year))}>} (MainAmount))

View solution in original post

5 Replies
chiru_thota
Specialist
Specialist

You ignore Month and other dimensions from the expression.


sum({$<Month=,Date=,Year = {$(=max(Year))}>} (MainAmount))

er_mohit
Master II
Master II

Try this

sum({<Year = {$(=max(Year))},MonthField=,Datefield=>} MainAmount)

MK_QSL
MVP
MVP

SUM({$<

          Year = {'$(=Max(Year))'},

          Field1YouWantToIngore = ,

          Field2YouWantToIngore = ,

          Field3YouWantToIngore =

          >}Amount)

maxgro
MVP
MVP

asmithids
Partner - Creator II
Partner - Creator II
Author

Thank you all for your help!