topic Re: Qvd's issue in QlikView

Qvd's issue

d_koti24 — Tue, 02 Jun 2015 08:31:25 GMT

Hi ,

I have 10 qvd's,taht qvd's contains year wise data,my req is I want to split that qvds into monthly wise qvds,that means each qvd splited into 12 qvds based on date field.instead of writeing script on every time ,I want create a subroutine and call that sub, pass the qvd name as a parameter.how to achive this?

Regards,

koti.

Re: Qvd's issue

vardhancse — Tue, 02 Jun 2015 08:35:28 GMT

Hi,

That can be done while creating the task in QMC by using loop and reduce option in Reduce<tab> of the QMc task, there we can define the field and value wise split, so that for every run the data will be splitted

Re: Qvd's issue

jonas_rezende — Tue, 02 Jun 2015 13:11:39 GMT

Hi.

The link below will help subroutine.

https://community.qlik.com/thread/74568.

Re: Qvd's issue

jonathandienst — Tue, 02 Jun 2015 13:29:44 GMT

Something like this:

ForEach vYearQVD in ('..\QVDs\Sales_*.qvd')

Let vYear = Right(SubField(vYearQVD, '.', 1), 4);

For i = 1 to 12

MonthQVD:

LOAD * FROM [$(vYearQVD)] (qvd)

WHERE Num(Month(TransDate)) = $(i);

Let vFilePrefix = Date(MakeDate(vYear, i, 1), 'YYYYMM';

STORE MonthQVD into [..\QVDs\Monthly\Sales_$(vFilePrefix).qvd'] (qvd);

DROP Table MonthQVD;

Assumptions:

Yearly QVDs are names Sales_YYYY.qvd (eg Sales_2014.qvd)
The yearly QVDs are in folder ..\QVDs
There is a date field in the QVD called TransDate
You want the monthly QVDs names Sales_YYYYMM.qvd
You want the monthly QVDs stored in ..\QVDs\Monthly

Adjust according to your specific requirements...

Re: Qvd's issue

Peter_Cammaert — Tue, 02 Jun 2015 13:30:27 GMT

Search the community, and you'll find lots of tips and tricks, and even solutions that are 90% complete.

Like: How to store the data of a table into Monthly and MonthEnd QVD's?

First load all your QVD's in a single resident table, then apply one of the solutions from that discussion.

Peter

Re: Qvd's issue

d_koti24 — Tue, 02 Jun 2015 15:01:07 GMT

Hi jonathan,
I have a one qvd(sample.qvd),that qvd contains the one year data.per ex :apr2014 to mar 2015,
i want to split that qvd into monthly wise qvd like sample.4.2014.qvd,
                                                    sample.5.2014.qvd,
                                                           .
                                                           .
                                                           .
                                                     sample.3.2015.qvd
and store that qvd's in req loc(ex:d:/qvds/sampleqvds)

i want to achive this by using sub routine.and that two paths(sample.qvd,sample.4.2015)pass as parameters.
that means i want to pass the sample.qvd path and monthlyqvds stored path.

ex: call sub('sampleqvd path','monthly stored qvds path')

how to achive this?

can you please send me a sample app...

Regards,