topic How to Update in QlikView

How to Update

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

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?

Re: How to Update

Anil_Babu_Samineni — Fri, 20 Oct 2017 06:04:38 GMT

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

Re: How to Update

soniasweety — Fri, 20 Oct 2017 06:16:00 GMT

is there any other way in qlik side can we achieve?

Re: How to Update

Anil_Babu_Samineni — Fri, 20 Oct 2017 06:36:53 GMT

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

Re: How to Update

soniasweety — Fri, 20 Oct 2017 15:49:20 GMT

thnx I will try and update you

Re: How to Update

Anil_Babu_Samineni — Sat, 21 Oct 2017 13:01:49 GMT

Great, once you figure out the suit answers you can close this thread by flag correct answer..