Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

How to Update

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?

5 Replies

Re: How to Update

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: How to Update

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

Re: How to Update

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: How to Update

thnx  I will try and update you

Re: How to Update

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)