real time processing data in QV

[#1]

Hello All

I have a strange requirment from our clients that

the data has to be updated dynamically in QV without reloading the dashboard.

Indetails:

I have an excel sheet with threecolumns salesID,SalesPerson. and SalesDate.

I have created a table with all the records in QV.

Now, if i add any new records in my tables without reload can that data be shown in Qv table that i created earlier?

I need new records to be shown without any reload.

please help me in this regard.

[datanibbler]

Hi,

I would be very astonished to learn that this is possible. In a program where, like QlikView, the data comes from somewhere else - e.g., it is not entered in QlikView itself, but in Excel or whatever - and moreover the GUI (charts and so) is separate from the program_logic (script and data) - the data has to somehow go from here to there, and that is not possible without moving the data - you have to load it.

You could in principle build a data_entry_form in QlikView, but a reload would still be necessary to get that new data into your table.

The only workaround would be if you holf all your data in variables (each variable being a list of values), but that would be somewhat complex.

Excel would be able to do this - well, not really, only the formulas and charts are dynamically updated and since you enter the data in the same file - if you do - that is possible without anything extra to do.

Sorry.

Best regards,

DataNibbler

[#3]

Hello DataNibbler,

Thanks for the reply.

Even me too looking for the possible outcome

i need to understand two things here in Qv

1) In document properties -> Server -> checking Enable Dynamic data update.

2) incremental load without refreshing the Qv to get the latest data

looking for some help in this regard

[datanibbler]

Hi,

I'm not sure about that "dynamic data update", but I believe there is some blog around here about that.

As to the incremental LOAD, that does not mean you don't have to reload with that - it merely means that only new data will be loaded, not the entire set of data over and over, meaning it will be a lot faster. Incremental LOAD is not something you can just activate, but you have to code it.

[#5]

Hi

I know the logic for incremental load.

but i need to found more extension for incremental load without reload.

Hope this may not be possible at this time with QV.

[petter]

You are right - there is an option of using Dynamic Update to do an in memory update of the running database for a particular application. But it has to be used with extreme caution because it is not very robust and maybe even quite buggy. So don't think that you can do this on a big application with a large amount of users...

Here is the extremely minimalistic documentation:

None of the updates done with this will be reflected back in the QVW that is the basis for the application. So care has to be taken by including the data that comes in from Dynamic Update for each later reload.

Warning: Dynamic Update is a "legacy feature" so use it at you own risk and don't expect any support for it.

[#7]

Thanks Petter,

but still in Qv Dynamic update example: we are using condition to set on which column and value to be updated.

but i want once we update in DB it should come to QV without hardcoding the same records in QV

I need some mechanism for updation (Know everything happens like a magic)

but our client needs somehing like this dyamic update of data in QV without any interaction.

[datanibbler]

Hi,

well, with that you're back with reloading. The possibility would be having an external process that constantly watches the size of that table or whatever there is and whenever that changes, it triggers a reload. I guess that would be the closest to a "reload without interaction" that you can go.

Best regards,

DataNibbler

[SreeniJD]

Create a windows batch file, and reload the QV without opening QV manually. This might works

Regards

Sreeni

[Anonymous]

Hi ,

You can create a buffer time in QMC as 5 seconds thus it will get automatically Reloaded(This buffer time based on the application !) or

else

we can use EDX triggering (ITs attached)

else

batch file  reload

'By accessing the button as 'Refresh' on access point ' will help the end user to get the latest data .

Thanks,

Bunny