Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

QVD

Hi,

Please find the attached QVD. This qvd contains five weeks data(from 2013W01 to 2013W05). I need this QVD to be separated into five qvd's based on week. I don't have any date field in this qvd.

Ex:2013W01 data should be in one qvd

2013W02 data should be in another qvd..

Please help me..

2 Replies
michael_maeuser
Contributor III

Re: QVD

see attached

Not applicable

Re: QVD

Hi

use a loop

ex :

T1:

For each Week in 1, 2, 3, 4, 5

do..

LOAD your QVD

where WeekField = $(Week)

STORE T1 into W$(Week).qvd;

drop Table T1;

next

best regards

chris