Native Write Table that's stored for 90days.

[chiragpatel]

Hi,

There is a native write table in Qlik Sense and is there a way to delete entries from it?

What's the best approach to do that?

Thank you

[Vegar]

There are not delete record functions available in QS, a common approach for this is to exclude the +90 days when you load your data.

Let's assume you store your 90 days of data in a qvd named 90d.qvd.

In the script do like this.

90d:

SELECT * FROM source_system WHERE <criteria that load new records from your source only>;

CONCATENATE (90d)

LOAD * FROM LIB://QVD/90d.qvd (qvd);