topic Re: getting last 7 years in QlikView

getting last 7 years

Tue, 28 Jun 2011 12:09:25 GMT

Hi to all,

how can i generate last 7 years in a Single variable dynamically. Either in macro or editscript.

Based on Current Year it should calculate last 7 Years.

Current Year =2011 , then last 7 years should display, as same below.

Ex:

ABCD

2010

2009

2008

2007

2006

2005

2004

If Current Year =2012 then last 7 years is 2011 to 2003.

How can i work on this ?

Regards

Venkat

getting last 7 years

swuehl — Tue, 28 Jun 2011 13:32:29 GMT

Hi,

I am not quite sure what you want to achieve.

Do you want to set a (comma separated) list of year values to a variable or use a certain period (last 7 years) for limiting the display / calculation of a dimension / expression?

From your post, I would assume the first; is Current year another variable /selection or do you want to use the current timestamp?

If you want the latter, I would use set analysis and limit for example dimension Year to the last 7 years.

e.g. sum( {$<Year = {">= $(=year(now())-8) <= $(=year(now())-1)"}>} Sales )

[Be aware that you might need to set other time dimensions to empty selection if needed within the set, depending your data model]

(Besides I think the last seven year for current year 2012 should be 2011 to 2005, right?)

Regards,

Stefan

Re: getting last 7 years

Tue, 28 Jun 2011 13:41:24 GMT

Hi Swuehl,

Pls can you see the attached sample QVW file.

What you mentioned in last line is correct. I need to display those years in a listbox.

I need to display last 7 years in a single variable.

Regards

Venkat