Reload qlikview desktop data from command line?

[#1]

Hi,

After searching for quite some days, I still don't succeed in reloading my data from the Windows command prompt.

Some background information:

Got some CSV files which are exported in a certain folder on certain time intervals.

These CSV files go into charts on Qlikview

Refresh the charts from command line (.bat file actually) (this part is not working)

I get the popup saying that I fetched x amounts of lines but I do not see any change in the charts.

Reloading data inside qlikview Desktop works (charts change), from .bat file does not.

I checked multiple security options but didn't change a thing.

What am I doing wrong?

Thanks in advance.

[awhitfield]

Hi Niels,

have you checked out:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Starting_QlikView.htm

Best regards

Andy

[#3]

Hello,

Thanks for the response.

I have read that manual and other docs.

My .bat file looks like this:

"C:\Program Files\QlikView\Qv.exe" /r /NoSecurity "C:\Users\Niels\Documents\test.qvw"

Still got no solution.

Best regards,

Niels

[awhitfield]

Try:

"C:\Program Files\QlikView\Qv.exe" r /NoSecurity C:\Users\Niels\Documents\test.qvw

No quoates in the doc path...

Andy

[#5]

Does not make a difference.

However, I found this:

If I do /l (that's an ell) instead of /r, it opens up a new screen, with the correctly updated data.

If I try to save, then the other screen that I had open (of the same Qlikview file that should stay open on a different monitor) doesn't change in data. Only if I close and re-open it.

Any idea how to fix this? Thanks a lot for the help.

Sincerely

Niels

[#6 · Accepted solution]

Managed to fix it in another way.

Not using a .bat file anymore, but using a variable in Qlikview.

The way I did it:

Create a variable, making it: =if(((now()-ReloadTime())*1440)>=1,999,0)

Create a trigger: whenever the variable changes, call a macro that reloads the document

This will give a loop that auto-refreshes the file.

Regards,

Niels

[jonathandienst]

qv.exe /r does not update the currently open document. It will open the document from disk, perform the reload and save the updated document back to disk. The open document is not affected.

qv.exe /l loads the document from disk, performs a reload and leaves the updated document open. You will need to save the document yourself. Any other instance open before the reload is not affected.

Hope that clarifies the switches.

[jonathandienst]

>>Any idea how to fix this?

Precisely what do you want to fix? The batch reload (qv.exe /r) is intended for non-interactive reloads. If you want an instantly updated interactive load, just open the document in the desktop and click reload.

[vvvvvvizard]

Dont forget to right click the file and run as administrater .

Schedule the task to run using windows task scheduler 

[#10]

Hi

You're right, I do get the purpose now.

I needed the interface to be kind of a real-time monitor, which is why I wanted to keep the editor open.

See my marked solution for the answer that I came up with/found online.

Regards

Niels