topic Re: Dates generation(ADDING future dates) in QlikView

Dates generation(ADDING future dates)

Wed, 25 Nov 2020 16:16:04 GMT

Hi I have scenario,

In my database i have data like below

year Sales

2005	45
2006	54
2007	25
2008	56
2009	78
2010	31
2011	25
2012	26
2013	85
2014	57
2015	95
2016	64

I want add years more 20 like below

Year	SalesGrowthRate
2005	45
2006	54
2007	25
2008	56
2009	78
2010	31
2011	25
2012	26
2013	85
2014	57
2015	95
2016	64
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034

For adding those above years what i need to do

Please do the needful

Thanks

Thiru

Re: Dates generation(ADDING future dates)

Michiel_QV_Fan — Mon, 13 Jun 2016 11:20:50 GMT

concatenate

load *

inline [

Year

2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034];

Re: Dates generation(ADDING future dates)

florentina_doga — Mon, 13 Jun 2016 11:22:30 GMT

concatenate

load 2016+recno() as year autogenarate(20)

like this

aa:

load * inline [an

2016];

concatenate(aa)

load 2016+recno() as an autogenerate(20);

Re: Dates generation(ADDING future dates)

akpofureenughwu — Mon, 13 Jun 2016 11:36:43 GMT

concatenate

load *

inline [

Year

2017
2018
2019
2020
2021
2022
2023
2024
2025 ]

This should work

Re: Dates generation(ADDING future dates)

florentina_doga — Mon, 13 Jun 2016 11:42:51 GMT

aa:

load * inline [year, Sales

2005, 45

2006, 54

2007, 25

2008, 56

2009, 78

2010, 31

2011, 25

2012, 26

2013, 85

2014, 57

2015, 95

2016, 64

];

max_year:

load distinct max(year) as year_max resident aa;

let v_max_year=peek('year_max',0,'max_year');

drop table max_year;

concatenate(aa)

load $(v_max_year)+recno() as year autogenerate(20);

Re: Dates generation(ADDING future dates)

Mon, 13 Jun 2016 12:08:10 GMT

Hi Thanks for your answer

If it is date stamp instead of year then this formula

let v_max_year=peek('year_max',0,'max_year'); will become

let v_max_year=addmonths(?

Please do the needful

i want to add months

Thanks

Thiru

Re: Dates generation(ADDING future dates)

florentina_doga — Mon, 13 Jun 2016 12:51:59 GMT

pls try this

aa:

load * inline [year, Sales

2005, 45

2006, 54

2007, 25

2008, 56

2009, 78

2010, 31

2011, 25

2012, 26

2013, 85

2014, 57

2015, 95

2016, 64

];

max_year:

load distinct max(year) as year_max resident aa;

let v_max_year=peek('year_max',0,'max_year');

drop table max_year;

concatenate(aa)

load $(v_max_year)+recno() as year autogenerate(20);

left join(aa)

load * inline [month

12];

NoConcatenate

bb:

load *,

makedate(year,month,1) as date

resident aa;

drop table aa;