Developing a Real Time Dashboard - Any advice?

[#1]

Hi,

Just about to start down the road working with a requirement for a 'almost realtime' call centre application - delivered using Qlikview server to a number of concurrent users.

Ive read through various threads about realtime updates, and also looked at the example app that is fed from excel. But could do with some further advice. Chances are the app will be fed through web services, either that or a sql database. And we could be talking thousands of updated every few minutes. I dont want users to have to exit and re-enter the app to get the updates I would like the app it self to refresh in from of them every few minutes.

Has anybody any advice about :

A. Whether this is feasible

B. Where to start

C. Any pitfalls to try and avoid

D. Any benefits of QV10 here (currently runing QVS 9)

E. Licence requirements (Currently on SBS, but upgrading to enterprise imminently)

As ever, I appreciate the help of the community. Many thanks, in advance, for your advice.

[#2]

Tengo la respuesta..

Spanish.

Este modulo permite ir actulizando cada cierto tiempo, por ejemplo 5 segundos un monitor de llamados con consultas a una base de datos SQL.

public sub RecargaLoad()

    ActiveDocument.ReloadEx 2,1

end sub

public sub ActivarHojas()

set var = ActiveDocument.Variables("varRecargaAuto")

set hoja=ActiveDocument.ActiveSheet

set modHoja= ActiveDocument.Variables("varFrecuenciaHoja") 

set modCarga= ActiveDocument.Variables("varFrecuenciaCarga")

if var.GetContent.String=1 then

       if (second(now()) mod  (cint(modCarga.GetContent.String) *5))= 0 then

          RecargaLoad           

       end if

end if

end sub

Variables que hay que definir:

varRecargaAuto = 0

varIntervalo = if (varRecargaAuto=1,Second(Now()),0)

Disparadores:

Asignar el disparador a la variable "varIntervalo" ejecutando la macro "ActivarHojas"

Si tienen dudas subo el modelo de ejemplo.

[pgalvezt]

Hola Cris,

me aparece esto

Object required: 'var'

Gracias,

[#4]

Debes declarar las variables que comienzan con "VAR", varRecargaAuto, crealas como enteros.

[pgalvezt]

La declaré como entero pero no se ejecuta.

Adjunto un test.

[pgalvezt]

Cree un botón con las mismas especificaciones y funciona la recarga. Pero de manera automática no funciona. Que puede ser?

Gracias,

[pgalvezt]

Alguna Ayuda?

Gracias