Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table with 4 columns only I don't have any date field in the data
,
MY requirement is : my data in database update every week Saturday
so my user wants the data to be updated in qlik application when the data uploaded in db.
so how to achieve this in qlik?
can anyone give the suggestions to achieve this?
You can schedule task for that in QMC like Week wise every Sunday reload (Because, DB might update between 12 AM - 11:50 PM anytime by Saturday). If we schedule Sunday then data may update automatically ...
is there any other way in qlik side can we achieve?
Either you need to create with one variable or else go with macro where i aware
LET a =if(left(subfield((now()-ReloadTime())*1440,'.',2),1)=5,999,0); // This is for every 5 minutes, you can set it up as needed
Macro
Sub ReloadDoc
ActiveDocument.Reload
ActiveDocument.Save
End sub
thnx I will try and update you
Great, once you figure out the suit answers you can close this thread by flag correct answer..