How to select data continuously filtering with last selection ID?

[lelasha]

I have data which increases every second,

My goal is to nonstop(if not possible 1 min could do its job) select data from database, after each selection remember the last id of selection data and filter next selection with last id
for example select * from db where id > last_selection_id limit 100

is this possible? I tried using reload task which reloads script no less than 1 min plus I couldn't filter the selection with last id of the previous selection.

[Brett_Bleess]

I believe what you are looking for is in the following Help link, and there are other posts on Community related to this method as well, and there may be some further conceptual posts in the QlikView Documents area too:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/QVD_Incremental...

https://community.qlik.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&f...

Hopefully those two links will get you on the right track.

You may also want to configure a Continuous Trigger on that task as well:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/QMC/Content/QV_QMC/QMC_Documents_SourceDoc...

See the Recurrence section and the Continuously option there.

Regards,
Brett