topic Re: Qlikview Personal edition reload with Windows task scheduler in QlikView

Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guy,

I am on PE at the moment, My requirement while evaluating Qlik for our company is below, Please can anybody help me on this

I have a very small amount of data from csv file, Now I have created couple of charts and want this to be automatically reload and update the records. The idea is to open the desktop edition on a screen in the office and schedule the reload every 15 mins so that the records gets updated, I have successfully made it to reload with -r command but this is not updating the records while the document is open, I also tried command L which always opens a new instance of desktop and updates the record but doesn't save the qvw which is fine, but am struggling to find a way to not open new instance but to show in the current open qvw (desktop itself), Is there a way to do this please...

Thanks for your help

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Fri, 12 Jan 2018 13:19:53 GMT

I am trying to do this which gives me desired result but.....since my schedule is for 15 mins it always opens a new instance rather than updating the already opened desktop , Any help to update in the exsiting opened document pleasee?? even with macros or whatsoever please. this is kind of urgent

L

This switch will open the report, load the script, and leave the report open for further processing and/or analysis. This is a convenient way to setup a Desktop shortcut for a specific report to reload when opened. Ex: “C:\Program Files\QlikView\QV.exe” /L “C:\My QV Data\Report1.qvw”

Re: Qlikview Personal edition reload with Windows task scheduler

marcus_sommer — Fri, 12 Jan 2018 14:10:29 GMT

I'm not sure if you could solve this task with command-line batches but with vbs-batches it could be possible. Here an example what is meant: Re: Vbs - passing parameters to opendoc or opendocex.

- Marcus

Re: Qlikview Personal edition reload with Windows task scheduler

rwunderlich — Fri, 12 Jan 2018 14:42:38 GMT

Take a look at using a keyboard simulator like AutoIt - AutoIt‌. You could have it run a Ctrl-r in the existing window every 15 minutes.

-Rob

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Fri, 12 Jan 2018 15:30:17 GMT

Hi Rob, Thanks for your reply, I have gone through the above link Autolt but didn't get my head around it how to implement this in my scenario, Can you please explain me if possible Thanks again

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Fri, 12 Jan 2018 15:37:59 GMT

Hi Marcus, Thanks for your reply, I have looked at your link, I am very much newbie to VBA scripting, I am trying to put your code from the above link in Qvw-->Edit Module-->VBScript

Option Explicit

Dim QA, QD, apppath, newdoc

apppath = "C:\Users\sandeep.movva\Desktop\cwdl_iot_dev\cwdl_iot_dev.qvw"

set QA = CreateObject("QlikTech.QlikView")

set QD = QA.ActiveDocument.GetApplication

set newdoc = QD.OpenDoc(apppath, "","")

newdoc.ReloadEx 0,1

newdoc.save

newdoc.CloseDoc

QD.Quit

Getting below error

"ActiveX component can't create object: 'QlikTech.QlikView'"

I have taken out param1 = inputBox("param: ") and param1 as I don't need to pass on any parameters, Can you please help me step by process to achieve this

Re: Qlikview Personal edition reload with Windows task scheduler

marcus_sommer — Fri, 12 Jan 2018 15:41:03 GMT

You need to enable system access for this modul - it's about in the mid of the left pane of the modul-editor.

- Marcus

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Fri, 12 Jan 2018 17:04:26 GMT

Hi Marcus,

I have enabled the system access,QV desktop hangs and closes after I click either Check at the top or click on OK, If I get this to work what will be the next step please? Do I need to schedule the windows task schedule and it will update the records in the same instance?

Thanks again

Re: Qlikview Personal edition reload with Windows task scheduler

marcus_sommer — Sat, 13 Jan 2018 06:28:54 GMT

It's difficult to say what might be wrong. I think it's creating a new QlikView instance where I'm not sure if it could work within QlikView itself. The example from above was meant to be in an external vbs-batch. However the probably best way to start with troubleshooting will be to reduce the code by uncommenting most parts and then enabling step by step the next parts until it runs.

Beside this I think I would use a bit different approach because if I understand your description right there is no user-action only displaying the dashboards by updating the data on regular basis. This would be:

Option Explicit

sub UpdateReport

Dim QD, doc

set QD = QA.ActiveDocument.GetApplication

set doc = ActiveDocument

for i = 1 to 1 * 4 * 12 'running 12 hours each 15 minutes

doc.ReloadEx 0,1

doc.save

QD.Sleep 1000 * 60 * 15 'sleep for 15 minutes

doc.CloseDoc

QD.Quit

end sub

This routine would be started from an OnOpen-trigger in the application and the application would be executed from the windows-task.

- Marcus

Re: Qlikview Personal edition reload with Windows task scheduler

swuehl — Sat, 13 Jan 2018 11:48:29 GMT

If you can't make Rob's solution work, try creating a timer in your qvw and call a simple macro to reload.

Attached a sample (reused a qvw from another post, Info screen with triggered selection).

Basically, create a variable that changes based on rounded now().

(Yes, using now() will add some load on your system and is not recommended in general, if you just need a kind of permanent display, this might not be an issue in your case)

Create a onChange trigger in document settings for that variable, with an macro call action.

Macro looks like

Sub Test

ActiveDocument.Reload

End sub´

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 15:27:07 GMT

Hi Marcus, Thanks for the reply, Yes you are right, There will be no user intervention, no filters nothing to select..its just a simple dashboard with few KPI's to be shown on a screen....so the desktop would be opened on the screen and it needs to update the records after every reload on a 15/30 mins frequency when I schedule through windows task manager (wtm), I have tried your approach to trigger in ON OPEN, but don't know its not updating..please see below my step by step process I followed in the attached document, Can you please let me know what I am doing wrong in achieving this please? Thanks a lot again

Automate QVW from personal desktop

Step 1)

This is my QVW, with a simple count(ID)

Step 2)

Opened SettingsàDocument propertiesàTriggersàOnOpenàActionsà

Step 3)

Click on edit module and copy pasted your code

When I click on Test at the top where it say ready in the above image it say’s “Variable is Undefined :’QA’, So tried changing Set QD = instead of Active document I have given my QVW name which is ReloadTest.qvw but it’s still the same

Step 4)

Clicked on OK and saved the document, closed and opened the document again and then created a WTS

My .bat file code is like this

"C:\Program Files\QlikView\Qv.exe" /r "C:\Users\sandeep.movva\Desktop\ReloadTest.qvw".

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 15:28:41 GMT

Hi Stefan,

As I am on Personal edition at the moment I am unable to open the document attached, Is it possible to let me know or the code to follow what I need to do please, This will be really helfull

Thanks a lot

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 15:31:24 GMT

Document attached of the step by step process

Re: Qlikview Personal edition reload with Windows task scheduler

marcus_sommer — Wed, 17 Jan 2018 16:41:20 GMT

Yes, the variable QA is wrong (left from the origin example) and needs to be removed. As a next step I would check if the macro runs like it should directly triggered from the modul-editor by pressing the button "Test" - of course by reducing the number of iterations and the time-span of the sleep-statement because 3 - 4 fast iterations are sufficient to check if the reloads are executed and afterwards the application closed or not.

Further in this logic you need only a daily trigger from the windows-tasks and not per quarter-hour because the loop within the macro does the regular reloadings.

Also the batch-file won't b needed because it could be directly defined within the windows-task and the starting-parameter should be /l and not /r:

- Marcus

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 16:54:47 GMT

I have taken out "set QD = QA.ActiveDocument.GetApplication" from the code, Now when I click on test it throws me "Variable is undefined: 'i'

Re: Qlikview Personal edition reload with Windows task scheduler

marcus_sommer — Wed, 17 Jan 2018 17:02:32 GMT

Try it with this:

...

Dim QD, doc, i

set QD = ActiveDocument.GetApplication

...

The message because i is caused from the Option Explicit which enforced that all used variables are declared before they could be called: Option Explicit Statement (Visual Basic) | Microsoft Docs

- Marcus

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 17:10:32 GMT

Thanks a lot, I have clicked on test button and it shows me executing, I will let you know once I finish my testing, If I understood right my net steps is to, Create windows task schedule with daily trigger and create a action with l statement...so hopefully this will all work as expected... I will let you know the outcome....Thanks really helpfull

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 17:47:10 GMT

Hi,

It is still opening separate instance when starting the reload..please find the screenshot in the attached, I have scheduled windows task to run daily which is starting from now which is 17:35, so it opened a new instance even though the same qvw is opened on a screen

I waited if it would reload on the new instance opened after 15 mins but it didn't ?

Re: Qlikview Personal edition reload with Windows task scheduler

Anonymous — Wed, 17 Jan 2018 17:58:33 GMT

Also after I click on test, it hangs at executing and when I close it forcefully and re open the document it shows me the updated records which means it actually is reloading and saving the document.....I think I am missing something small here where I need to take care? Can you please suggest me from the above information please

Thanks again

Re: Qlikview Personal edition reload with Windows task scheduler

swuehl — Wed, 17 Jan 2018 18:06:13 GMT

1) Create a test script that changes value (to show the successful reload):

LOAD Ceil(RAND()*10) as Test

autogenerate 1;

2) Reload

3) Create listbox for field Test

4) Create a Macro

5) Create a Variable vVar

=Round(Now() , maketime(0,0,15))

(for a 15 second reload)

=Round(Now() , maketime(0,15,0))

for a 15 minute reload

6) Create a variable onChange trigger in Settings-Document properties - Triggers: