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: 
Silambarasan1306
Creator III
Creator III

Nullification in Set Analysis..??

Hi All,

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

Thank u,

5 Replies
isorinrusu
Partner - Creator III
Partner - Creator III

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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

prashanthivongala
Contributor
Contributor

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.