Discussion Board for collaboration on QlikView Scripting.
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..
use a loop
For each Week in 1, 2, 3, 4, 5
LOAD your QVD
where WeekField = $(Week)
STORE T1 into W$(Week).qvd;
drop Table T1;