Nullification in Set Analysis..??

[Silambarasan1306]

Hi All,

Could anyone clarify nullify concept in set analysis. i.e ( Year=, Quarter=, Month=)

Thank u,

[isorinrusu]

Hi Silambarasan,

What Year= does is to ignore the user selections on the Year field.

For example, if you have a bar chart with Year as the X-axis and sum({<Year=>}Sales) as the Y-axis (with values 2012 to 2016), and a user selects 2014, no change would be made in the chart. It would still show all 5 years.

Regards,

Sorin.

[Silambarasan1306]

I'm clear with that .I want to know why we are nullifying month & Quarter in YTD.

[sunny_talwar]

If we won't ignore selection in Month and Quarter fields, then selections in these fields will filter your YTD to just those months which you have selected or those quarters which you have selected. So in order to avoid month and quarter selections to take effect, we need to ignore them.

Does that make sense?

[Silambarasan1306]

Yaa i'm clear sunny. Thanks for your valuable reply.

[prashanthivongala]

Hi Sunny,

I am writing an expression like this :

=sum({$<FiscalYear=,FiscalMonth=,FiscalQuarter=,Date={">=$(=YearStart(Max(Date),-2,4))<=$(=AddYears(Max(Date),-2))"}>}amount)

In this i am trying to nullify but it is not working .Could you please help in this .

Many thanks in advance.