topic Re: Re: Re: Qvd separation in QlikView

Qvd separation

Thu, 12 Dec 2013 11:18:28 GMT

Hi,

I have a QVD with five weeks.i need each week as a single qvd.

ex:2013W01->1qvd

2013W02->1qvd

etc.....please find the attachment.

Thanks

Re: Qvd separation

Thu, 12 Dec 2013 11:27:24 GMT

Try something like the following:

let vMaxWeek = max(week(date))

let vMinWeek = min(week(date))

let QVDDirectory = 'your directory'

FOR i = $(vMinWeek) TO $(vMaxWeek)

LET t = "Week_" & ($(i));

load * from your table

where i = week(date)

STORE [$(t)] INTO [$(QVDDirectory)\DM_$(t).QVD] (qvd);

NEXT i

LET vTotalTables = NULL();
LET t = NULL();

Re: Qvd separation

Thu, 12 Dec 2013 11:34:51 GMT

to be precise

week(date)-> weekname(date)

LET t = "Week_" & replace(weekname($(i)),'/','') maybe...

Re: Qvd separation

giakoum — Thu, 12 Dec 2013 11:42:14 GMT

Please see attached file :

LOAD week

FROM

C:\Users\user\Downloads\week.qvd

(qvd);

IF NoOfRows('week') > 0 THEN

FOR j = 1 TO FIELDVALUECOUNT('week')

LET currentWeek = FIELDVALUE('week',$(j));

[$(currentWeek)]:

LOAD

'$(currentWeek)' as FilteredWeek

AutoGenerate(1);

STORE [$(currentWeek)] into C:\Users\user\Downloads\$(currentWeek).qvd (qvd);

DROP Table [$(currentWeek)];

ENDIF

Re: Qvd separation

Thu, 12 Dec 2013 15:57:46 GMT

Hi Ionnis, Thanks for your reply.I need the single qvd to be splitted into five Qvd's based on week. Thanks Gowthami

Re: Qvd separation

giakoum — Thu, 12 Dec 2013 17:10:18 GMT

Well that is exactly what this script does. Did you try it?

Re: Re: Qvd separation

Fri, 13 Dec 2013 06:06:56 GMT

Hi Ioannis

Thanks for your reply. I tried with your script, its working fine. But I am trying to do the same with the attached Qvd, am not able to generate Qvd's. Pls help me.,

Regards,

Gowthami

Re: Qvd separation

Fri, 13 Dec 2013 06:48:19 GMT

Try this,

If u have a date field in ur table then do likethis

YearWeek:

Load distinct Yearweek(Datefield) as weekyear from sales.qvd order by Datefield;

Rows=Noofrows(Yearweek)-1;

Startrow=0;

Yearweek=Filedvalue(weekyear,$(Startrow));

Ta:

Load * fron Sales.qvd where Yearweek(Datefiled)=$(Yearweek);

Store tab into "F:\Sales_$(Yearweek)";

Startrow=Startrow+1;

while(Rows>=Startrow)

Regards,

Kabilan K.

Re: Qvd separation

Fri, 13 Dec 2013 06:59:36 GMT

Pls change the Yearweek() function as Weekname() in my prev reply

Re: Re: Re: Qvd separation

giakoum — Fri, 13 Dec 2013 13:36:51 GMT

Please check out attached file

Re: Re: Re: Qvd separation

Fri, 13 Dec 2013 14:42:45 GMT

Hi Ioannis,

Thank you for your reply. Its working fine.

Regards,

Gowthami