topic Re: dynamical year range in QlikView

dynamical year range

Tue, 26 Mar 2013 07:25:57 GMT

Hi All,

The year filed having the data from 2005 to 2080 in the database.

But we need to load only 50 years of data only.

Every 5 years they will consider as AMP.

Ex: AMP1 AMP2 AMP3 .... AMP15

2006-2010 2011-2015 2016-2020 .... 2075-2080

Ex: The AMP for the current year is AMP2

Now the year range should be like this

"Previous AMP+Current AMP+40 Years" Means 2006-2010+2011-2015+40 (2006-2055)

Note: Year should be a financial Year

How to write the condition as per the Year range specification in the script which will take the year range dynamically?

Hope you understand the requirement.

Thanks in advance..

Regards

Kumar

jagan — Tue, 26 Mar 2013 08:23:23 GMT

Hi,

Can you attach some sample records, so that it would be easier to understand.

Regards,

Jagan.

kaushiknsolanki — Tue, 26 Mar 2013 08:54:16 GMT

Hi,

Find the attachment.

Hope this is what you want.

Regards,

Kaushik Solanki

Tue, 26 Mar 2013 10:13:10 GMT

Hi Jagan,

Please check the attachment for sample data which i have prepared for AMP1.

Small correction in my previous post:

AMP1

2005-Apr to 2010-Mar (5 Years)

Like this for other AMP's.

Regards

Kumar