topic Re: Browser reload 'hack' in QlikView

Browser reload 'hack'

Mon, 01 Jun 2015 09:19:57 GMT

We have a small document on our server that we want the user to be able to trigger the reload from the browser. I quickly realised the trigger events don't function from the browser and have looked into this here on the community. The correct way to do this seems complicated and rather long winded for such a simple document.

So after a bit of thinking I came up with a bit of a hack to get around this however I have hit several brick walls and wonder if you know any trick that might work.

The theory:

Set up a variable (_Reload) with an input box on the document.

Set the document to reload every 10mins (for example).

In the script - if _Reload = 1 the reload script (setting _Reload back to 0 at the end) else Exit script.

When I use the exit script function all the tables are lost - no data

When I try to change the ErrorMode this also causes all table to be empty. This also has the undesirable effect of triggering email 'failed reload' spam which seems to be a server setting not a document setting...?

The reason we want the user to be able to trigger the reload is because of changes made to an input Excel table and if the document reloaded regularly (without actually 'reloading') this would avoid unnecessary load on the server and if the Excel doc was changed it would only be 10mins before the user had a result they could then straight away export to Excel to work on.

I know this isn't the correct way to do this but any advice would be very helpful.

Oli

Re: Browser reload 'hack'

awhitfield — Mon, 01 Jun 2015 09:34:26 GMT

Hi music_43,

would it not be simpler to just set up the document to reload every 10 mins in QMC?

HTH Andy

Re: Browser reload 'hack'

Gysbert_Wassenaar — Mon, 01 Jun 2015 09:41:55 GMT

See this blog post: http://www.qlikblog.at/2321/qliktip-47-reloading-qlikview-documents-using-the-ajax-mobile-client-triggering-edx-tasks-by-using-a-qlikview-extension/

Re: Browser reload 'hack'

Mon, 01 Jun 2015 10:57:09 GMT

Hi awhitfield‌

This is what we have done, but I was trying to avoid adding extra load on the server....?

Oli

Re: Browser reload 'hack'

Mon, 01 Jun 2015 10:58:44 GMT

Hi gwassenaar‌

I had been to this very useful sight but it seemed complicated (especially for the project I am working on now) but I guess this will be the only way?

Thanks

Oli

Re: Browser reload 'hack'

Anonymous — Mon, 01 Jun 2015 11:02:45 GMT

How many users will be using the using the dashboard qvw ?

Re: Browser reload 'hack'

Mon, 01 Jun 2015 11:06:13 GMT

Hi bill.markham‌

Just the one.

Re: Browser reload 'hack'

Anonymous — Mon, 01 Jun 2015 11:21:30 GMT

Trying to set up user initiated reloads on the QV Server is a right pain as you have discovered and in my opinion not what QlikView is designed to do. [From experience I have found it to be unreliable as well]

For just one user, I would suggest they are given a licence to use the QV Desktop and then they can reload the qvw to their hearts content.

..... or you could even create a QlikSense qvf dashboard for them and the foc QlikSense Desktop would work perfectly for their needs.

Re: Browser reload 'hack'

Mon, 01 Jun 2015 11:29:13 GMT

bill.markham‌

Thank you for your advice and honest opinion.

I think the QlikSense might work and make my boss less nervous about granting this individual too much access to the data.

Thanks again

Oli

Re: Browser reload 'hack'

Anonymous — Mon, 01 Jun 2015 12:24:03 GMT

I don't know if you have used QlikSense yet, but if not this could be a great opportunity for you get your hands dirty and learn about it. It is never bad to add extra things onto your CV.