Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to split Qvd into saparate partition Qvds in Qlikview?

Hi..

I have one qvd i want to saparate Single Qvd into different Qvds absed on month. plaease help me..

Please find following attachment attachment contains Qvd Related data..

Regards,

Chandini.G

7 Replies
sushil353
Master II
Master II

Hi,

Try below code:

Temp:

LOAD Distinct MonthName(Date_DATE_TIME) as Dates

FROM

IVRREPORTDATA_CALLINFO.qvd

(qvd);

let vrows = NoOfRows('Temp');

for i=0 to $(vrows)-1

let vMonth = peek('Dates',$(i),'Temp');

table:

LOAD CallID,

     ApplicationID,

     CallDateTime,

     Date_DATE_TIME,

     Time_DATE_TIME,

     SessionID,

     Status,

     ABANDONED_FLAG,

     CALL_END_REASON,

     CALLID,

     CALLORIGINTYPE,

     CATEGORY,

     SUBCATEGORY,

     CIRCLEID,

     CLI,

     DISPOSITION,

     CALLINFO_DNIS,

     DTMFPATH,

     ENDDATETIME,

     ENDTYPE,

     ERR_REASON,

     GATEWAYIP,

     HOW_CALL_ENDED,

     HUB,

     ICR,

     LANGCODE,

     LASTMENUACCESSED,

     MENUPATH,

     MOBILENUM,

     RTR_CL_KEY,

     RTR_CL_KEY_DAY,

     RTR_SEQ_NUM,

     KEY_COLUMN,

     SERVICEPATH,

     SESSIONID,

     STARTDATETIME,

     TPIN_BLOCKED,

     TPIN_CHANGED,

     TPIN_RESET,

     TRANSCODE,

     TRANSFERVDN,

     TRANSTOIVR,

     VXMLIP,

     MANAGEDACCESS,

     XFERBARRED,

     IVRBARRED,

     RESERVE1,

     RESERVE2,

     RESERVE3,

     RESERVE4,

     RESERVE5,

     RESERVE6,

     RESERVE7,

     RESERVE8,

     RESERVE9,

     RESERVE10

FROM

IVRREPORTDATA_CALLINFO.qvd

(qvd)

where MonthName(Date_DATE_TIME) = '$(vMonth)';

store table into table_$(vMonth).qvd(qvd);

DROP Table table;

NEXT i;

HTh

Sushil

Anonymous
Not applicable
Author

Hi Shushil..

Thanks For your response...

which I table i have to drop here..

sushil353
Master II
Master II

Hi, Didn't get your question..

You can create a temp_table for storing the data into qlikview..

If your issue is fullfilled then mark the thread as answered so that other get benifit..

Anonymous
Not applicable
Author

Hi..

In code we mentioned

store table into D:\chandini\New folder\Qvds\Month\table_$(vMonth).qvd(qvd);

so month wise data tables stores in D:\chandini\New folder\Qvds\Month in path but i didnot find any tables in path.

Thanks,

Chandini.G

sushil353
Master II
Master II

Hi,

This is working for me..

You will get table_Aug 2014.qvd in the path specified.

if still, you face any issue then post your code.


Anonymous
Not applicable
Author

Hi ..

I didnot get...

My code is

Temp1:

LOAD Distinct MonthName(Date_DATE_TIME) as Dates

FROM

D:\chandini\New folder\Qvds\IVRREPORTDATA_CALLINFO.qvd

(qvd);

let vrows = NoOfRows('Temp');

for i=0 to $(vrows)-1

let vMonth = peek('Dates',$(i),'Temp1');

table:

LOAD CallID,

     ApplicationID,

     CallDateTime,

     Date_DATE_TIME,

     Time_DATE_TIME,

     SessionID,

     Status,

     ABANDONED_FLAG,

     CALL_END_REASON,

     CALLID,

     CALLORIGINTYPE,

     CATEGORY,

     SUBCATEGORY,

     CIRCLEID,

     CLI,

     DISPOSITION,

     CALLINFO_DNIS,

     DTMFPATH,

     ENDDATETIME,

     ENDTYPE,

     ERR_REASON,

     GATEWAYIP,

     HOW_CALL_ENDED,

     HUB,

     ICR,

     LANGCODE,

     LASTMENUACCESSED,

     MENUPATH,

     MOBILENUM,

     RTR_CL_KEY,

     RTR_CL_KEY_DAY,

     RTR_SEQ_NUM,

     KEY_COLUMN,

     SERVICEPATH,

     SESSIONID,

     STARTDATETIME,

     TPIN_BLOCKED,

     TPIN_CHANGED,

     TPIN_RESET,

     TRANSCODE,

     TRANSFERVDN,

     TRANSTOIVR,

     VXMLIP,

     MANAGEDACCESS,

     XFERBARRED,

     IVRBARRED,

     RESERVE1,

     RESERVE2,

     RESERVE3,

     RESERVE4,

     RESERVE5,

     RESERVE6,

     RESERVE7,

     RESERVE8,

     RESERVE9,

     RESERVE10

FROM

D:\chandini\New folder\Qvds\IVRREPORTDATA_CALLINFO.qvd

(qvd)

where MonthName(Date_DATE_TIME) = '$(vMonth)';

store table into D:\chandini\New folder\Qvds\Month\table_$(vMonth).qvd(qvd);

DROP Table table;

NEXT i;

Anonymous
Not applicable
Author

Hi..

I got it its working fine..

Thanks,

Chandini