Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

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
Highlighted

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)
Highlighted
Master
Master

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

Highlighted

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)
Highlighted
Master
Master

thnx  I will try and update you

Highlighted

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)