topic Re: optimize the script in App Development

optimize the script

olguita2014 — Mon, 20 Dec 2021 21:38:40 GMT

Hi,

Please help me!!!!... I whan to optimize my sentences of my script:

VEH_STOCK:
Load Distinct
Clave_CompraDetalle_Kardex_Vehiculo,
If(Sum(Cantidad_Saldo)=0,'Sin Saldo','Con Saldo') as Estado_Saldo
Resident VEH_KARDEX
Group By Clave_CompraDetalle_Kardex_Vehiculo,Fecha_Kardex;

This code has problems of optimization, What can I do to change the script?

Re: optimize the script

pradosh_thakur — Sun, 17 Feb 2019 06:23:14 GMT

VEH_STOCK:
load Clave_CompraDetalle_Kardex_Vehiculo,
Fecha_Kardex,
If(Sum(Cantidad_Saldo)=0,'Sin Saldo','Con Saldo') as Estado_Saldo,
Group By Clave_CompraDetalle_Kardex_Vehiculo,Fecha_Kardex;
Load Distinct
Clave_CompraDetalle_Kardex_Vehiculo,
Fecha_Kardex,
Cantidad_Saldo
Resident VEH_KARDEX
Order By Clave_CompraDetalle_Kardex_Vehiculo,Fecha_Kardex;

Have a look at the document

https://community.qlik.com/t5/QlikView-Documents/Optimize-Group-By-Performance/ta-p/1481470/page/2/show-comments/true

Re: optimize the script

Anil_Babu_Samineni — Mon, 18 Feb 2019 04:02:10 GMT

@pradosh_thakur Qlik internally optimize as always using Order By clause. Preferably like

Temp: // Temp table applied descending order with all rows from fields mentioned
Load Clave_CompraDetalle_Kardex_Vehiculo, Fecha_Kardex, Cantidad_Saldo 
Resident VEH_KARDEX 
Order By Clave_CompraDetalle_Kardex_Vehiculo,Fecha_Kardex;
VEH_STOCK: // This is the final table, 
Where It can optimize the way of concepts with aggregate functions
NoConcatenate
load Clave_CompraDetalle_Kardex_Vehiculo,
Fecha_Kardex,
If(Sum(Cantidad_Saldo)=0,'Sin Saldo','Con Saldo') as Estado_Saldo,
Group By Clave_CompraDetalle_Kardex_Vehiculo,Fecha_Kardex;