I run the same NP report in NP 17 tasks using different Filters, and for one report I see an hourglass in the chart, when I rerun the same task with exact the same filters chart is fixed, sometimes.
What might cause this? I can't manually review each report before sending to client, there are 300+ of them.
Your chart expression takes too much time to calculate. I suggest:
Review chart expression and optimise it as much as possible
if present - replace IF with Set Analysis
Use flags in set analysis
Make sure you have optimised data model
If present and possible - replace calculated dimension with fields from model
If all above is already done - contact Qlik support (open support ticket) as default timeout value will have to be changed I believe...
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
how big is a data model (no of rows in fact table / dimension tables)
screenshot of your data model (table viewer)
dimensions and expressions used in your chart
maybe there is something we can help you with (in terms of optimisation). Also since it is NPrinting report with QlikView:
do you need to use this application?
do you have any other objects on the sheet where this object is placed
are all objects minimised on this sheet?
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
