How to perform Partial Reload with Left Join on Qlik?

user42_qlik — Thu, 08 Jun 2023 14:53:27 GMT

I have a Qlik script where I load two tables, Product and Customer. I join these two tables on a common field called Purchase_ID using a left join. I want to do a partial reload on the Customer table using the Partial Reload button to see the updates when new customers are added to the Customer table. However, this does not update my sheet when the Partial Reload option is selected as shown below:

I tried using the ADD ONLY LOAD option but this requires me to click the Reload button each time I load the dashboard, else I get an Incomplete Visualization error as it loads the Customer table only when a Partial Reload is initiated. I also tried using an if PartialReload = 0 then ... endif condition for the Product table but I get a No Table to Join error.

How can I do a Partial Reload in this situation? Here is my script for reference:

LOAD 
    Product_ID, 
    Cost_Per_Unit, 
    Purchase_ID,
    Date
FROM Product
WHERE Date > '2023-06-01'

LEFT JOIN

ADD LOAD 
    Customer_ID, 
    Purchase_ID
FROM Customer

Re: How to perform Partial Reload with Left Join on Qlik?

Digvijay_Singh — Fri, 09 Jun 2023 03:26:02 GMT

Looks like partial reload and join don't work properly as per this support article -

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Partial-reload-does-not-work-with-JOIN-and-DROP/ta-p/1982553

topic How to perform Partial Reload with Left Join on Qlik? in App Development

How to perform Partial Reload with Left Join on Qlik?

Re: How to perform Partial Reload with Left Join on Qlik?