Line with Total and Average using subquery / Linha com Total e Media usando subconsulta

Mon, 26 Jan 2026 18:19:17 GMT

Hello good Morning. You can perform a subquery on qlik.

Example of a subquery that made no sql wanted to redo via Qlik

Olá, Bom Dia. É possível realizar uma subconsulta no qlik .

Exemplo de uma subconsulta que fiz no sql queria refazer via Qlik

no sql :

SELECT '' AS R,

ISNULL(P_APPARATUS,0) AS P_APPARATUS,

ISNULL(PAYMENTINTEREST,0) AS PAYMENTINTEREST,

ISNULL(INTERNACIONAL,0) AS INTERNACIONAL,

VALORF,

DTVENCIMENTO ,id

FROM VW_DEFPERFIL01

UNION ALL

SELECT

'TOTAL' AS R,

SUM(ISNULL(P_APPARATUS,0)) AS P_APPARATUS,

SUM(ISNULL(PAYMENTINTEREST,0)) AS PAYMENTINTEREST,

SUM(ISNULL(INTERNACIONAL,0)) AS INTERNACIONAL,

SUM(VALORF) , '' AS DTVENCIMENTO , '0' AS id

FROM VW_DEFPERFIL01

UNION ALL

SELECT

'MEDIA' AS R,

AVG(ISNULL(P_APPARATUS,0)) AS P_APPARATUS,

AVG(ISNULL(PAYMENTINTEREST,0)) AS PAYMENTINTEREST,

AVG(ISNULL(INTERNACIONAL,0)) AS INTERNACIONAL,

AVG(VALORF), '' AS DTVENCIMENTO, '0' AS id

FROM VW_DEFPERFIL01

Why this subquery ??

To put a total and a half line in my report.

porque esta subconsulta??

para colocar uma linha de total e media no meu relatório.

Mensagem editada por: ednilton souza

topic Line with Total and Average using subquery / Linha com Total e Media usando subconsulta in QlikView