Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to track historic data in QVD

Hi All,

I connecting to Oracle database and pulling Session log from v$session, but It is having only sessions for latest data for 5min .I need to store the trend for rolling 4 hr.I can't refresh qvd every 5 min.

What is the best way to handle this type of situation.

Thanks,

Rahul

3 Replies

Re: How to track historic data in QVD

Hi,

I think for this you have to store data in qvd every 5 minute you load.

upon completion of 4 hours remove the required data.

Regards

ASHFAQ

Not applicable

Re: How to track historic data in QVD

Refreshing qvd every 5  min is not acceptable in our server.Due to performance issue.

konstantin
Contributor III

Re: How to track historic data in QVD

I would suggest to contact with DBA and make data storage for v$session data, if it doesn't work you need to load data to the  qvd every 5 minutes with previous data loads concatenation (see "Incremental data loading")

Community Browser