Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bmensing
Contributor III
Contributor III

How to get historical data

Hey there,

i want to get a history of my data. E.g. the data of my table "xyz"  on the reload date 23.07.2017 is like that:

orderID amount

1           100

2           200

tomorrow the 24.07.2017 its:

orderID amount

1           120

2           240

I want to get a master qvw which i can use to get graphs about the development of the amount sorted by id. The Master qvw looks like this:

orderID      reload date       reload time       amount

Anyone got a plan or at least know where to find a guide...

Many thanks in advance

2 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

May be like at attached file? Autogenerate a large number that would load lasted at least 1-2 seconds.

Regards,

Andrey

sebastianlettner
Partner - Creator
Partner - Creator

Halle,

this looks like you need an incermental load.

I think this links should help you.

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/QVD_Incremental.htm

Incremental Load.docx

Best regards

Sebastian