sheet 1 take value from qvd1 and sheet2 from qvd2.

[#1]

i have two sheet(single edit script). i want sheet1 take value from qvd1 and sheet2 from qvd2.

how will i do this? please help me...........

[#2]

Post ur sample Data which will fetch you results quickly .

Cheers ,

Bhushan N

[#3]

i can share you my edit script-

connection string---------------

//other than error

SUMMARY:
SQL SELECT a.* FROM summary_pcs a;

//store Qlikview Table from memory to disk

store SUMMARY into E:\qlikview\SUMMARY.qvd (qvd);

LOAD
timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID,CONTENT_PROVIDER_ID,ACCOUNT_TYPE,CONTENT_NAME,
YEAR(timestamp(EVENT_DATE,'DD/MM/YY')) as YEAR,PICK(month(timestamp(EVENT_DATE,'DD/MM/YY')),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')AS MONTH,DAY(timestamp(EVENT_DATE,'DD/MM/YY')) AS Day,
sum(AOC_SHOWED) , sum(AOC_REJECTED), sum(AOC_OK),sum(PURCHASE_FAILURE),SUM(PURCHASE_REVENUE),SUM(RENEWAL_REVENUE),SUM(PREMIUM_COUNT),SUM(CANCEL_COUNT),SUM(PURCHASE_COUNT),SUM(RENEWAL_COUNT)
FROM SUMMARY.QVD (QVD)
group by timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID,CONTENT_PROVIDER_ID,ACCOUNT_TYPE,CONTENT_NAME;

//error related
SUMMARY_PCS_ERRORS:
SQL SELECT B.* FROM SUMMARY_PCS_ERRORS B;

store SUMMARY_PCS_ERRORS into E:\qlikview\SUMMARY_PCS_ERRORS.qvd (qvd);

LOAD
timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID ,CONTENT_PROVIDER_ID,
YEAR(timestamp(EVENT_DATE,'DD/MM/YY')) as YEAR,PICK(month(timestamp(EVENT_DATE,'DD/MM/YY')),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')AS MONTH,
DAY(timestamp(EVENT_DATE,'DD/MM/YY')) AS Day,count(VALIDATION_ERROR)
FROM SUMMARY_PCS_ERRORS.QVD (QVD)
group by timestamp(EVENT_DATE,'DD/MM/YY') , CHARGING_PROFILE_TYPE_ID ,CONTENT_PROFILE_ID , CONTENT_ID,CONTENT_PROVIDER_ID;

[#4]

You can use Qualify & UnQulaify command to separate these tabes and if you dont want to link these tables .

Bhushan N