Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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