Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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