topic Re: Is there a way assign an aggregated load statement to a variable? in QlikView

Is there a way assign an aggregated load statement to a variable?

julioarriaga — Fri, 27 Jul 2018 00:57:14 GMT

Hi,

I want to know if there is any way of assigning an aggregated load statement to a variable just as in SQL

Thanks in advance.

Example:

DECLARE @vAnioCY INT=2018;
DECLARE @vECOCY FLOAT;

SET @vECOCY=(
SELECT AVG(ECO_Icalificacion)
FROM TH_EncuestaECO E
INNER JOIN Td_Tiempo T ON E.TPO_CFecha=T.TPO_CFecha
WHERE TPO_CAnioFiscal=@vAnioCY
)

Re: Is there a way assign an aggregated load statement to a variable?

BalaBhaskar_Qlik — Fri, 27 Jul 2018 06:29:18 GMT

ABC:

Load *;

SQL

SELECT AVG(ECO_Icalificacion) as Avg_Value

FROM TH_EncuestaECO E

INNER JOIN Td_Tiempo T ON E.TPO_CFecha=T.TPO_CFecha

WHERE TPO_CAnioFiscal=@vAnioCY;

Let vAvg = Peek('Avg_Value',0,'ABC');

Let vAvg = Fieldvalue('Avg_Value',1);

Drop table ABC;

Use the above variable in different tables.