topic Re: Document taking time when opening in QlikView

Document taking time when opening

ferha_jafri — Fri, 09 Jun 2017 08:04:57 GMT

Hello Everyone,

I am facing a problem and not sure why is it happening I have a document which is taking time to open , the problem is when I am triggering that application with Today date variable it is taking same time although when I am saving the application with that day selected and open it again , it is opening in sec not sure what is happening. Can anyone help.

Thanks in advance

Ferha Sharma

Re: Document taking time when opening

kamal_sanguri — Fri, 09 Jun 2017 08:35:31 GMT

Trigger is slowing down your application. When you open your document your objects are again calculated with the value new value of variable. Do you have object with large data/ complex calculation / If statements etc.?

Re: Document taking time when opening

sujeetsingh — Fri, 09 Jun 2017 08:37:17 GMT

Check for any on select triggers on open trigger. Many times they hangs the app.

Re: Document taking time when opening

ferha_jafri — Fri, 09 Jun 2017 09:04:15 GMT

Yes , the front part has many and complicated expressions.

Re: Document taking time when opening

kamal_sanguri — Fri, 09 Jun 2017 09:11:46 GMT

that's the reason, they are getting calculated again once your variable gets a value after opening document. Nothing much you can do about it.

Still few points -

*if you have multiple sheets in your document, try making default to one which has simple objects (if possible).

*you can do complex calculation in script and not at front end (may take lot of rework).

*you can minimize the object with complex calculation, it will restrict the object from recalculation.

Re: Document taking time when opening

ferha_jafri — Fri, 09 Jun 2017 10:56:51 GMT

Hello Everyone,

We are trying to place trigger in the application to open for one date but it is still taking 2 min time , we tried all the possible triggers but no go , here I have a question which I could not understand as when we select one date in date field and save the document and close it and open it again , it is opening in few sec but if we are implementing the trigger it is again taking 2 min time my question is why is it happening as we are reducing the data but the ways are different.