topic Concatenate within a loop in QlikView

Concatenate within a loop

Anonymous — Thu, 28 Jul 2016 13:50:37 GMT

Hi All,

I have 3 monthly QVDs .What i wish to achieve is make one single QVD containing data of 3 months

I need to achieve under a loop as the QVDs to be fetched are dynamic based on variables

I can't use load * because based on current month last 3 months will keep changing.

Any help appreciated .

Thanks and Regards,

Nishant Nadkarni

Re: Concatenate within a loop

Peter_Cammaert — Thu, 28 Jul 2016 15:29:47 GMT

Can you post a few more details? What do you mean by "...QVDs to be fetched are dynamic based on variables..."? What do those variables contain? And what are the names of the QVD files?

Best,

Peter

Re: Concatenate within a loop

Anonymous — Fri, 29 Jul 2016 06:31:25 GMT

Hi Peter,

QVD names are like Fact_$(vMonth1),Fact_$(vMonth2),Fact_$(vMonth3)

and the variables vMonth1 ,vMonth2 and vMonth3 contain values for last 3 months

eg. Apr-2016,May-2016,June-2016 ...

I have written this inside a loop and at the end I am storing this concatenated data inside a single QVD .My final QVD contains data only for June-2016 whereas what I need is data for all 3 months.

Thanks and Regards,

Nishant Nadkarni