How to perform Partial Reload with Left Join on Qlik?
I have a Qlik script where I load two tables,ProductandCustomer. I join these two tables on a common field calledPurchase_IDusing a left join. I want to do a partial reload on theCustomertable using the Partial Reload button to see the updates when new customers are added to theCustomertable. However, this does not update my sheet when the Partial Reload option is selected as shown below:
I tried using theADD ONLY LOADoption but this requires me to click the Reload button each time I load the dashboard, else I get anIncomplete Visualizationerror as it loads theCustomertable only when a Partial Reload is initiated. I also tried using anif PartialReload = 0 then ... endifcondition for the Product table but I get aNo Table to Joinerror.
How can I do a Partial Reload in this situation? Here is my script for reference:
WHERE Date > '2023-06-01'