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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksense30
Contributor III
Contributor III

need help on qlik generator

Need help

2 Replies
qliksense30
Contributor III
Contributor III
Author

I have sql query , which i  hardcoded the month.

I have 5 years data like this and i dont want multiple include statements to get included in the script. 

I have 5 years data which i need to extract on moth basis. 

Is there any automated way on this. 

So that for one country ,  i can use the include statement (.qvs) to generate all months data extarction. 

Please help me.

 

Please find the attached qvw and sql query above  which i have  hardcoded

qliksense30
Contributor III
Contributor III
Author

Hi anyone please help on this