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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[new QV user] tap into RTDB

Hi all,

I am very new to QlikView, just started playing around with this amazing tool and found out my life could be so much easier coming from SSRS.

I have created a few basic reports in QlikView tapping datasource from our db directly. I find that every time new data is required, there is a need to modify and re-load the script.

Is there anyway to present the report with the latest data from db without reloading the script? as in real-time?

I apologize if my question sound confuse.


Cheers,

Jeff

5 Replies
hector
Specialist
Specialist

Hi,

QlikView doesn't work in real-time, it works based in "snapshots" of your data, and needs to be reloaded every time you need to refresh the info (in server environment, exists a button Refresh, but i don't think is that you want)

good luck with your work in QlikView.

c ya!

Not applicable
Author

but i also see a real-time dashboard in the call center demo. is that "real" real-time?

in the QlikView reference manual it mentions:

2.6 Real-time data update
Dynamic Data Update
For the first time in QlikView history it is possible to programmatically
update field data in real-time without running the script. Via new APIs and
more or less standard SQL insert, update and delete commands, any
QlikView field data can be updated directly in RAM. On a server the
updated data is pushed out to the clients.
This functionality is freely available in stand-alone QlikView but requires an
additional license on QlikView Server. See the QlikView API Guide for
more information.

I am using a personal edition, does it offer real-time data update?

hector
Specialist
Specialist

Hi, as i know this real-time feature is for Update/Delete values, not for retrieve new rows of the tables.

c ya.

johnw
Champion III
Champion III

My understanding is that the real time update allows you to push the data from your database into QlikView. That's the opposite of normal, which is for QlikView to pull the data from the database. So yes, there is a way to present the report and latest data from the database without reloading the script. However, I haven't used it yet, so can't advise you on how to get it working.

Not applicable
Author

Thanks John, I think you are correct, need to find a way to test this real-time update push feature.