Foor Loop

Mon, 14 Sep 2015 07:21:10 GMT

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

topic Foor Loop in QlikView

Foor Loop