Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Shushil..
Thanks For your response...
which I table i have to drop here..
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..
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
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.
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;
Hi..
I got it its working fine..
Thanks,
Chandini