topic Re: Multiple QVD are duplicating repetitive in Application in QlikView

Multiple QVD are duplicating repetitive in Application

Anonymous — Fri, 12 Dec 2014 09:29:03 GMT

Please refer word doc suggest solution ASAP:

Generating Repetitive QVD in QVD Loop.Problem is we have $(Sales_Country): Table for Incremental load we wrote logic if Office&[Account period] as Keycal, and renamed to [Sales Keycal]if this is same Replace old data else Concatenate to new data

$(vProjectOGISQvdDir)\$ (Sale_Logic).qvd
(qvd)
where NOT exists([Sales Keycal]);

But to generate year wise Qvd Split written logic with in temp:resident of Increment table.

Problem facing:

QVD are generating for Incremental data .

By using same incremental table name VD are splitting into Year wise and giving Same data in QVD

Can any one help on how to integrate Year wise QVD Temp table code below the Incremental Load.

So that there will not be any more repetitive qvd.

solution expecting on

I need to integrate QVD Splitting Year wise Code below the Incremental load

Concatenate
LOAD *
FROM
$(vProjectOGISQvdDir)\$ (Sale_Logic).qvd
(qvd)
where NOT exists([Sales Keycal]);

Re: Multiple QVD are duplicating repetitive in Application

Anonymous — Fri, 12 Dec 2014 10:33:27 GMT

Any help on this please stuck with errors .Any solution on QVD generation logic optimization .In word doc will give Reference for the problem

Re: Multiple QVD are duplicating repetitive in Application

marcus_sommer — Fri, 12 Dec 2014 11:45:33 GMT

I think the reason for your not working script is how is exists() used. Exists() didn't work on table-level else on field-level for the entire loaded data. This meant without dropping your resident table it couldn't work (store as qvd and loaded from there). Further not exists() worked only with absolute unique keys on record-level:

http://community.qlik.com/message/667486#667486

- Marcus

Re: Multiple QVD are duplicating repetitive in Application

Anonymous — Fri, 12 Dec 2014 12:46:33 GMT

My Requirement is in Incremental Load logic we have used where NOT exists([Sales Keycal]); as it is based on requirement giving desired output and generating qvd .But need to integrate the Year wise qvd generation logic after concatenate Load

Re: Multiple QVD are duplicating repetitive in Application

marcus_sommer — Fri, 12 Dec 2014 13:26:01 GMT

It is not a question of whether but how. Therefore read my comment again and check the hints here:

http://community.qlik.com/search.jspa?q=incremental+load

- Marcus