Need Help .

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I got a task to optimize the qlikview script as the performance is slow when dealing with large numbers of data.

The original data flow diagram .

sample model attached.

I need a POC , so I have started with the left side of the diagram.

I have only pulled limited data .

Please have a look in the script. if the left join made are correct to optimize the model.

Now , I want to get the expression to be done in script .

How to get the script done for the below highlight expression.

I have tried this in the script . But not working.

Tab Latestforstate -

"TotalApplication":

LOAD

deal_id,

'1' as FlagTotalApplication

Resident "Deal"

where (dealstate_id=8 or dealstate_id=9 or dealstate_id=33 or dealstate_id = 34 or dealstate_id = 35);

left Join ("Deal")

Load *

Resident "TotalApplication";

drop table "TotalApplication";

"Approved":

LOAD

deal_id,

'1' as FlagApproved

Resident "Deal"

where (dealstate_id=33 and LatestForPodium =1);

left Join ("Deal")

Load *

Resident "Approved";

drop table "Approved";

"Test":

Load Distinct

deal_id,

Count(FlagTotalApplication) as CountTotalApplication,

Count(FlagApproved) as CountApproved

Resident "Deal"

Group by deal_id;

Re: Need Help .

YoussefBelloum — Wed, 07 Mar 2018 15:24:46 GMT

Hi,

can you attach some rows or sample data from every table loaded here ?

First to take a look at the structure and second to be able to reload