set expression for not effected by other selections

[balasundaram]

i need set expression to show current year data..but not effected by other selections.

[PrashantSangle]

Hi,

Nullify otherfield in your set analysis.

Like

Sum({<DateField={">=$(=yearstart(today()))"},Month=,Day=>}Sales)

This way you can achive currente YEar Sales regardless other selection

[ajaykumar1]

Hi,

Try like this.

e.g. 1.      sum({<Year ={'2014'},month=,date=,product=>}sales)

2......sum({<Year ={"$(=year(today()))"},month=,date=,product=>}sales)

If your selecting the month,date,product fields then it will not reflect in the expression.

Regards,

Ajay

[Anonymous]

you Need to define those selections who shall not modify your result by "Selection=" (selection will have no effect to calculation)

sum{<year={}selectedyear},Selection1=,Selection2=,Selectionn..>}Anything

[MK_QSL]

SUM({1<Year = {'$(=Year(Today()))'}>}Sales)

[stigchel]

You do not need to qualify all fields just use the 1 set qualifier like this:

Sum({1<Year={$(=Max(YearField))}>}

[CELAMBARASAN]

Try

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

here 1 represents ignores all selections