Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

deleting old data with partial reload

Hi, I am partial loading Data via ODBC. My Problem : the QlikView Document is growing to fast. In my table is a Timestamp and I wanted to delete all data older than 3 Months. Is there any way to do this with partial Reload?

2 Replies
shumailh
Creator III
Creator III

Are you saying you dont have any date field through which you can identify records? OR this timestamp field is having date aswell?

If you have date field then you can work with it by system date and schedule it in publisher to save loading time.

Shumail

Not applicable
Author

Hi, I have a datefield, my problem is, that my qlikview-file is too big and it have data from 6 or 7 months. now I want to delete the old data (older than 3months) with the same partial reload it gets the new data.