topic Re: set analysis? in QlikView

set analysis?

Anonymous — Fri, 26 Sep 2014 09:33:30 GMT

i have years list box like

year:

[

2000

2001

2002

2003

2004

2005

2006

2007

2008

];

my req is when i click on any year i want to get sales from that year to next 3 years.

like if i select 2002 then 2002,2003,2004,2005 sales i want see

like wise 2003 if i select then 2004,2005,2006,2007

how? please give me expression

Re: set analysis?

Fri, 26 Sep 2014 09:39:36 GMT

Try this

sum( {<year={'>=(=max(year)) =<(=Max(year)+3)'}>} Sales)

Re: set analysis?

Anonymous — Fri, 26 Sep 2014 09:41:51 GMT

inkoka question pettanu adhi chusara

Re: set analysis?

Fri, 26 Sep 2014 09:45:34 GMT

Try this

Here if you select a year it vl display from that year and above three years which u selected.

sum( {<year={'>=(=max(year)) =<(=Max(year)+3)'}>} Sales)

Here if you select a year it vl display above four years which u selected year.

sum( {<year={'>=(=max(year)+1) =<(=Max(year)+4)'}>} Sales)

Re: set analysis?

sujeetsingh — Fri, 26 Sep 2014 09:46:25 GMT

Why not to try iff

Re: set analysis?

manideep78 — Fri, 26 Sep 2014 09:50:07 GMT

Hello,

Please communicate in English Language so that everyone in this community will try to help you.

I hope you understand. Thanks

Regards,

Manideep

Re: set analysis?

senpradip007 — Fri, 26 Sep 2014 09:55:50 GMT

PFA. Hope it will serve your purpose.

Re: set analysis?

CELAMBARASAN — Fri, 26 Sep 2014 09:57:14 GMT

Hi,

Try this

1. " if i select 2002 then 2002,2003,2004,2005 sales i want see"

Sum( {<Year={'>=(=Max(Year)) <=(=Max(Year)+3)'}>} Sales)

2. "2003 if i select then 2004,2005,2006,2007"

Sum( {<Year={'>=(=Max(Year)+1) <=(=Max(Year)+4)'}>} Sales)

Re: set analysis?

tcullinane — Fri, 26 Sep 2014 10:28:52 GMT

if you are looking to display each year rather than an accumulation might be easier to use variables so that;

vCurrentYear = max(Year)

vNextYear = vCurrentYear+1

vNextNextear = ....etc

and reference the variables rather than the field in expressions

Re: set analysis?

Anonymous — Fri, 26 Sep 2014 10:48:48 GMT

Hi Manideep,

I agree, but we have discussed at that time not realted to qv.