topic Set Analysis - Annual Sum in QlikView

Set Analysis - Annual Sum

asmithids — Thu, 20 Mar 2014 03:21:57 GMT

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.

Re: Set Analysis - Annual Sum

chiru_thota — Thu, 20 Mar 2014 03:31:40 GMT

You ignore Month and other dimensions from the expression.

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

Re: Set Analysis - Annual Sum

er_mohit — Thu, 20 Mar 2014 05:20:59 GMT

Try this

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

Re: Set Analysis - Annual Sum

MK_QSL — Thu, 20 Mar 2014 07:14:51 GMT

SUM({$<

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

Field1YouWantToIngore = ,

Field2YouWantToIngore = ,

Field3YouWantToIngore =

>}Amount)

Re: Set Analysis - Annual Sum

maxgro — Thu, 20 Mar 2014 07:23:09 GMT

perhaps this can helps you

Ignore all selections except some specific fields using Set Analysis

Re: Set Analysis - Annual Sum

asmithids — Thu, 20 Mar 2014 14:21:41 GMT

Thank you all for your help!