Set Analysis

[qlikview979]

Hi Experts,

I have Year,Sales fields, Year field like

Year

2010

2011

2012

2013

2014

2015

2016

but i want to calculate sales between years(2011-2015) by using set analysis.

How Can i write the Expression.

Regards,

Mahesh

[Gysbert_Wassenaar]

sum({<Year={'>=2011<=2015'}>}Sales)

[qlikview979]

Hi Bro,

Thanks Its working.

But I Have two Variables

Vmax=Max(Year)

Vmin=Min(Year)

How can i use this

[vijetas42]

Instead of hard coding year you can use variables like this way,sum({<Year={'<=$(Vmax)>=$(Vmin)'}>}sales)

[Gysbert_Wassenaar · Accepted solution]

sum({<Year={'>=$(Vmin)<=$(Vmax)'}>}Sales)

[qlikview979]

Hi  Vijeta,

Thanks  its working 

I have one more doubt   Where can i use YearEnd().

Regards

[qlikview979]

Hi Thanks Bro,

Its working Perfectly.

I have one more doubt   Where can i use YearEnd().

Regards

[Gysbert_Wassenaar]

Somewhere were you need to calculate the last day (and time) of the year of a date. See the help file for more information.

[qlikview979]

Hi,

Thanks Bro,

Regards

Mahesh