Need help on qlik generator

[qliksense30]

I have one qlik country generator.

i included sql query as qvs file .

i need the current month and previuos month  query need to be loaded daily..

For the previuos months(historic 5 years data) i dont want to hard code as i have to include multiple qvs stattements need to get written.

Currently i have hardcoded .

Can any one please help me how to automate  using one include statement...

--

IS THERE ANY FOR LOOP CONDITION IS THERE SO THAT I CAN AUTOMATE  AND ALSO INLINE LOAD FOR CALLING ALL MONTHS DATA.

CAN ANYONE PLEASE HELP ON THIS

--

Please find the sql query below which i hardcoded.

AND D52.MNTHYR_R= $( MONTHYR)

AND D52.COUNTRY_ISO3_C =$(COUNTRY)

Sql Query:

Please find the attached sql query in word format and i have hardcoded as above

[qliksense30]

hI CAN ANYONE PLEASE HELP ON THIS

[qliksense30]

Hi

 Can anyone help on this