topic Real time data to QV? in QlikView

Real time data to QV?

Anonymous — Mon, 18 May 2015 09:59:20 GMT

Hi All,

What are the possibilities to get REAL Time data from DB into QVW, other than regular re load process .

Is that possible,if so how to achieve the same.

Kindly share your inputs

-Jay

Re: Real time data to QV?

jonathandienst — Mon, 18 May 2015 10:08:35 GMT

Qlikview has no true real-time capabilities, but you have 2 options to get near real time data:

Direct Discovery (search here for direct discovery) - the data is refreshed when the user opens a chart using the data
Scheduled partial reloads - partition the source data into a daily load portion and a dynamic portion. The daily load is a normal load (which might use an incremental load). The dynamic portion is a partial load (and would usually only load changes and/or new records). If this partial reload is fast enough, then it could be scheduled to run frequently (every 5 mins, 10 mins, 15 mins as required).

Both of these will require analysis of the data sources and modification and optimisation of your data model and load script

HTH

Jonathah

Re: Real time data to QV?

ToniKautto — Mon, 18 May 2015 10:14:04 GMT

The key thing with jontydkpi‌'s reply is that QlikView is not a real time tool.

The Direct Discovery feature could look like the real time answer at first sight, but it also depends on a reload cycle where dimension data is loaded into memory.

I quite often find that people look for real time data, but when the requirements are analysed a bit several minutes latency on data update time is acceptable. Why do you need real time data? What is the nature of the data, that makes it critical to analyse in real time?

Re: Real time data to QV?

Thu, 09 Feb 2017 17:42:12 GMT

We are also experiencing refresh/reload issue and yes, in our case, we need real-time data.

We use QlikView OCX to generate a call center dashboard with number of calls waiting, longest wait time, etc... Data is very limited though and from a single data source.

e originally select QlikView for its flexibility to configure your own dashboard layout.

Anyone aware of a solution to our problem?

Re: Real time data to QV?

stantrolav — Fri, 28 Apr 2017 13:31:48 GMT

Use PartialLoad.

It's cool thing. concatenate partial loads to your tables and you can get what you want.