topic Re: Second version of same qvd in QlikView

Second version of same qvd

Mon, 15 Dec 2014 19:18:46 GMT

T_BDE_DAILY:
LOAD
[Loan Number],
[First Principal Balance] as UPB,
[Hi Type],
[Lo Type],
[Next Payment Due Date] as [Payment Due Date]

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' and [Servicing Sold ID] <> 'X22' and [Referral Code] <> 'ssw' ;

The above is in a tab and represents the main filter for a report

I know need to pull from another version of the exact database qvd. The only difference is this version only uses the first part of the where statement

T_BDE_DAILY_temp:
LOAD
[Loan Number],
[First Principal Balance] as UPB,
[Hi Type],
[Lo Type],
[Next Payment Due Date] as [Payment Due Date]

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' ;

Is it better to create a file and use a right join in the same tab or would it be better to create a new tab

Re: Second version of same qvd

MK_QSL — Mon, 15 Dec 2014 19:37:07 GMT

FullQVD:

Load * From QVDName;

NoConcatenate

T1:
Load * Resident FullQVD where condition....

T2:
Load * Resident FullQVD where condition....

Drop Table FullQVD;

Re: Second version of same qvd

its_anandrjs — Mon, 15 Dec 2014 20:38:49 GMT

Hi,

As i understand if you are load second table with filter part A only for records with this filter but you already filter that rows in the first load. But in second load difference is that you load only only [Loss Mit Status Code] = 'A'.

Then try one of this ways

1. First Way

T_BDE_DAILY:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

Right Join

T_BDE_DAILY_temp:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

2. Second Way is

T_BDE_DAILY:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

Concatenate

T_BDE_DAILY_temp:

Load * From T_BDE_DAILY.qvd Where Conditions..........;

Regards

Anand