Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

silambarasan130
Contributor II

Nullification in Set Analysis..??

Hi All,

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

Thank u,

4 Replies
isorinrusu
Contributor II

Re: Nullification in Set Analysis..??

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.

silambarasan130
Contributor II

Re: Nullification in Set Analysis..??

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

Re: Nullification in Set Analysis..??

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?

silambarasan130
Contributor II

Re: Nullification in Set Analysis..??

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

Community Browser