Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
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
Anil_Babu_Samineni

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
Master
Master
Author

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

Anil_Babu_Samineni

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
Master
Master
Author

thnx  I will try and update you

Anil_Babu_Samineni

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)