Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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?
Hi, as i know this real-time feature is for Update/Delete values, not for retrieve new rows of the tables.
c ya.
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.
Thanks John, I think you are correct, need to find a way to test this real-time update push feature.