Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

how create number of qvds at a time in qlikview

Hi Friends,

please chech\k below image and code.

LOAD * Inline[

             TableName

             CustomerLegar

             DimAccount

             DimCustomer

             DimEmployee

             DimProduct

             DimProductCategory

            

];

for i = 1 to FieldValueCount('TableName')

let Vtable = FieldValue('TableName',i);

select  * from $(Vtable);

store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd(qvd);

Next

Error.png

3 Replies
MVP
MVP

Re: how create number of qvds at a time in qlikview

may be try below

for i = 1 to FieldValueCount('TableName')

let Vtable = FieldValue('TableName','$(i)');

select  * from $(Vtable);

store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd(qvd);

Next

EDIT:
I think we are missing the extension of the file we are going to load first..

MVP
MVP

Re: how create number of qvds at a time in qlikview

add a space

LOAD * Inline[

LOAD * Inline [

Not applicable

Re: how create number of qvds at a time in qlikview

Try following code.

You forgot to add LOAD before SQL

for i = 1 to FieldValueCount('TableName')

let Vtable = FieldValue('TableName','$(i)');

    $(vTable):

            LOAD

            *

        ;

        SQL select * from $(vTable)

        ;

store $(Vtable) into C:\Users\AMMANANA\Documents\QVDSavePath\$(Vtable).qvd;

DROP TABLE $(vTable);

NEXT