topic Re: How to split QVD generator year wise in QlikView

How to split QVD generator year wise

Wed, 04 Dec 2013 13:55:54 GMT

Hi,

Instead of adding all the data in QVD file, have to load qvds based on splitting the calendar year.

Which need to be done using For Next loop.

EG: Fact contains 5 years of data.

So I need separate QVD for each year which need to be done through For loop.

Please help me in how to achieve the above logic

Thanks & Regards,

Shobharani

Re: How to split QVD generator year wise

Wed, 04 Dec 2013 14:28:52 GMT

Hi,

for i=2013 to 2014
test:
LOAD Quantity,
     Customer,
     City,
     Year
FROM

(biff, embedded labels, table is Sheet1$) where Year=$(i);

store test into test_$(i).qvd;

Regards

Ashish

Re: How to split QVD generator year wise

Thu, 05 Dec 2013 05:34:02 GMT

Hi Ashish kumar,

Thanks for the reply!!!

How to concatenate splitted qvd's in 1 qvw using for next loop..

Thanks & Reagrds,

Shobharani

Re: How to split QVD generator year wise

jagan — Thu, 05 Dec 2013 06:21:20 GMT

Hi,

Try like this

Test:

LOAD Quantity,

Customer,

City,

Year

AUTOGENERATE (0);

for i=2013 to 2014

Concatenate(Test)

LOAD Quantity,

Customer,

City,

Year

FROM

test_$(i).qvd (qvd);

Regards,

Jagan.

Re: How to split QVD generator year wise

Anonymous — Thu, 05 Dec 2013 06:26:43 GMT

You can also use

LOAD Quantity,

Customer,

City,

Year

FROM

test_*.qvd (qvd);

In this way also data can be concatenated , so no need for for loop.