topic Re. :Refresh after reload in QlikView

Refresh after reload

Fri, 01 Apr 2011 13:01:23 GMT

Hello!

I'm reloading QlikView with a scheduled task. I have opened QlikView and I execute the task but the information is not refreshed.

In the task I have put: "C:\Qv.exe" /r /v "C:\Example.qvw"

THANKS!!!!!!

Re. :Refresh after reload

Fri, 01 Apr 2011 13:09:30 GMT

Hi aritzaresti,

Are u sure that your QV.Exe is on "C:\" ?

Normally, it's installed in "C:\Program Files\QlickView\".

Check this first and tell me.

Kindly,

Re. :Refresh after reload

Fri, 01 Apr 2011 13:19:50 GMT

Hi again,

Another point :

You use the switch /v (pass a variable) but you don't pass any value.

Example from Rob Wunderlich:

1. The variable must be predefined in your qvw. Use Settings, Variable Overview to add the variable "MyVar". You do not need to assign it any value.

2. Use the variable in the command line switch
/vMyVar=file2.csv

3. Then you can receive the variable in the script as follows.
LOAD * FROM $(MyVar);

Kindly,

Re. :Refresh after reload

Fri, 01 Apr 2011 13:34:10 GMT

Hello NALLET!

My QV.Exe isn't on "C:\", I've put it to simplify.

And the /v is because I've read something about automatic reload in one post. I dind't know its function 😞

Re. :Re: Re. :Refresh after reload

Fri, 01 Apr 2011 13:39:26 GMT

Oki 😉

See below the list of possible switchs (i know that it doesn't answer your problem but ...)

/r	Reload, save, close.
/rp	Partial-Reload, save, close.
/l	Reload, leave open.
/p	Partial-Reload, leave open.
/v	Pass variable.

Re. :Refresh after reload

Fri, 01 Apr 2011 13:51:28 GMT

I created a test.qvw.

After, i created a scheduled task with this command line :

"C:\Documents and Settings\All Users\Start Menu\Programs\QlikView\QlikView 10.lnk" /r "C:\Documents and Settings\e0145004\My Documents\QlikView_DEV\QV_APPLI\ZZ_Tests\test.qvw"

This works but, are you sure that you have permission to execute scheduled tasks on your machine. Perhaps must you execute your task with an administrator account?

Re. :Refresh after reload

Fri, 01 Apr 2011 14:03:51 GMT

The problem is if you have QlikView opened. The task works perfectly but the screen is not refreshed.

Re. :Refresh after reload

Fri, 01 Apr 2011 14:12:38 GMT

Sorry, i didn't understood.

the problem is that refresh command is only available with on QlikView Server.

Help, for refresh command says :

"This command is only available with documents opened on QlikView Server and when there is a newer version of the document available on the server. When invoking a refresh, you will get access to the latest data while maintaining your session including selections and layout state."

Hope you'll find another solution, perhaps with a trigger "OnPostReload" for example, and a macro !?

Good luck.

Kindly,

Re. :Refresh after reload

Fri, 01 Apr 2011 14:15:57 GMT

Thaks for all!

Have a happy weekend!