topic set analysis in QlikView

set analysis

Thu, 04 Dec 2014 05:44:50 GMT

I have a year field and it contains the values from 2000 to 2010. I need set expression in such way that, i want to select previous 4 year information along with current selection. For example if i select 2004, i should get the the 2000, 2001, 2002 and 2003 information along with 2004.

Re: set analysis

tresB — Thu, 04 Dec 2014 05:47:54 GMT

Try like:

Sum({<Year={">$(=Max(Year)-4) <=$(=Max(Year))"}>} Sales)

Re: set analysis

amit_saini — Thu, 04 Dec 2014 05:49:09 GMT

Viresh,

Try like this:

Sum({<Year = {"$(=max(Year)-4)"}>}Sales)

Thanks,

Re: set analysis

jagadeesh_diamo — Thu, 04 Dec 2014 06:10:39 GMT

you can use a trigger that triggers a 'select in field action' to select the next 4 years as well.

Take a look below and test the attached if you need

create a variable v1=max(year)

sum({<year={'=>(v1) <=(v1-4)'} Sales)

Thanks,

Jagadeesh

Re: set analysis

Anonymous — Thu, 04 Dec 2014 07:46:06 GMT

create a variable V1=MAX(Year)

sum({<year={'=>(V1) <=(V1-4)'} QTY)

Re: set analysis

avkeep01 — Thu, 04 Dec 2014 11:49:58 GMT

Hi Viresh,

I've attached some documentation about Set analysis that i found on the forum. Maybe it will help you.

Regards,

Anton