Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
migueldfr_23
Contributor III
Contributor III

Crear un boton de recarga de datos con recarga parcial

Buenos dias a todos,
Quiero crear un boton de recarga de datos para una hoja de real-time.

Para ello he añadido un boton para que se pueda recargar en demanada.

migueldfr_23_0-1732618407631.pngmigueldfr_23_1-1732618419053.png

Me da opción a elegir en las propiedades "Recarga Parcial" y he visto que si pones una linea en el script de carga, solo se carga la tabla que quieras reemplazar. Las demas quedarian para la carga a traves de "task" (preautomatizada)

migueldfr_23_2-1732618483138.png

 

Saludos y muchas gracias

 

Labels (4)
5 Replies
martinpohl
Partner - Master
Partner - Master

the problem with the reload by a button is, that this only can use the owner of the app.

If the app is published and a user is click on the button, the reload won't be done.

Regards

migueldfr_23
Contributor III
Contributor III
Author

Thanks for the response.
So how can I achieve the use case ? 
Thank you 

martinpohl
Partner - Master
Partner - Master

maybe using this?

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

 

Qlik Sense is a BI system, not an ERP, so why need to reload the datas every minute?

migueldfr_23
Contributor III
Contributor III
Author

Hello @martinpohl,
Thanks for reply

Yes, in this particular case I would need to allow to the user reload the data in real-time in order to check how the data trend goes.


Simply, another feature which enhance the report requested by the key.

I was wondering if it is feasible to do it

Thank you 

migueldfr_23
Contributor III
Contributor III
Author

Hello there, 

The approach will be something like this.

If(IsPartialreload() = true()) then

LIB CONNECT TO 'Athena';

IF TableNumber('tablename') >= 0 THEN
DROP TABLE tablename;
END IF;

"Table which want to be reload at the time"

else

"Rest of the code for reloading by task"