Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Foor Loop

Hi All

I hope you all are doing good!!!

I am expecting some one help me on the below  issue,

I have a qvw file which is generating qvds for every 28 days. in the attachment the period loop is running up to 13 periods  for the Current years also, however can we restrict the loop up to todays date. if yes how do we restrict it?

now I want to perform an incremental load to the latest qvd. if period is change qvd also change according to the period.

say I have 2 years of data   28*13=364 days  I may have 13 qvds for each year,

let's  say  I have data up to 18 September 2015 which is fall under period 4, from the next day my period while change to period 5.

at that time my incremental load should be table_2015_ 04.qvd and latest data from 19 September 2015. then the qvd has to store with

the name of current period. how can I get this.

Regards

John

0 Replies