Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload qlikview desktop data from command line?

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.

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

10 Replies
awhitfield
Partner - Champion
Partner - Champion

Not applicable
Author

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
Partner - Champion
Partner - Champion

Try:

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


No quoates in the doc path...


Andy

Not applicable
Author

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

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

>>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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vvvvvvizard
Specialist
Specialist

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

Schedule the task to run using windows task scheduler 

Not applicable
Author

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