Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please upload your / a sample QVW that demonstrates this issue.
Please find the qvw attached....I have commented out my variable since it is loading every second....As I am on personal edition I will not be able to open the document you send back, so any screen shots will be much appreciated
Thanks a lot Stefan, Also to be more clear from the below link I am facing the same issue as Carlos whose comment is the second last one
Auto reload every 10 minutes – desktop client | Lucian Cotea
Seems like your issue is not due to QV version. What OS are you using?
If you disable the trigger for now, and you use this variable definition
You should see an integer in your variable input box, increasing by 1 every 15 seconds.
What do you see?
Hi,
Yes I can see it increasing it to every 15 secs....I am using windows, See attached please
Thanks
Hm, your trigger seems to fire more often than expected.
Try this as workaround for now:
Create another variable vCheck, add this variable to your input box.
Change your macro to:
Sub Reload
set varTest1 = ActiveDocument.Variables("vTest")
set varTest2 = ActiveDocument.Variables("vCheck")
If varTest1.GetContent.String = varTest2.GetContent.String then
ActiveDocument.Reload
varTest2.SetContent varTest1.GetContent.String +1 , true
end if
End sub
and enable the macro in your trigger action.
Now change the variable vCheck in your input box to the value currently shown in vTest+1
and wait...
Hi, It seems to do nothing, Please see the attached doc with screen shots of what I am doing, Please correct me if I am wrong, Sorry...
Also the input box values are changing but reload is not triggered...
Apologies for being a pain....
Edit....
Finally I have made it work...I was confused not adding vTest+1... So anybody who looks at this post for reference, Above code from Stefan is Charm & document is all good but in the vCheck variable created I have to add +1 value...which means for example If vTest is showing 5 I need to enter 6 in Variable vCheck definition, From then on it Auto reloads...The very tiny thing is if the document is closed and re opened I need to do a manual reload and change vCheck = vTest+1 value according to vTest
Thanks a lot Stefan,,,,,You are really helpful, am not able to get around why it seems to trigger more than expected from the before code
Ok, now that it's working, you can create an OnOpen document trigger in Settings- Document properties and create an external - Set Variable action.
Set vCheck to
=Div(Round(Frac(Now())*60*60*24),15)+2
//start vCheck when opening the document with an initial timer value +2 (+1 should be sufficient, add 2 just to avoid a race condition on start up).
edit:
And if you want to keep the application running over night / midnight, you need to remove the frac() function from the variable definition / OnOpen tigger action:
=Div(Round((Now())*60*60*24),15) // 15 seconds