Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamical year range

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

3 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Find the attachment.

     Hope this is what you want.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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