Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chandinig
Creator
Creator

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

chandinig
Creator
Creator
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..

chandinig
Creator
Creator
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.


chandinig
Creator
Creator
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;

chandinig
Creator
Creator
Author

Hi..

I got it its working fine..

Thanks,

Chandini