topic Re: Set Analysis in QlikView

Set Analysis

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis

Gysbert_Wassenaar — Wed, 20 Jul 2016 07:00:11 GMT

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

Re: Set Analysis

qlikview979 — Wed, 20 Jul 2016 07:05:11 GMT

Hi Bro,

Thanks Its working.

But I Have two Variables

Vmax=Max(Year)

Vmin=Min(Year)

How can i use this

Re: Set Analysis

vijetas42 — Wed, 20 Jul 2016 07:13:13 GMT

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

Re: Set Analysis

Gysbert_Wassenaar — Wed, 20 Jul 2016 07:16:22 GMT

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

Re: Set Analysis

qlikview979 — Wed, 20 Jul 2016 07:16:43 GMT

Hi Vijeta,

Thanks its working

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

Regards

Re: Set Analysis

qlikview979 — Wed, 20 Jul 2016 07:17:28 GMT

Hi Thanks Bro,

Its working Perfectly.

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

Regards

Re: Set Analysis

Gysbert_Wassenaar — Wed, 20 Jul 2016 07:21:26 GMT

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

Re: Set Analysis

qlikview979 — Wed, 20 Jul 2016 07:23:32 GMT

Hi,

Thanks Bro,

Regards

Mahesh