topic How to SQL Query into QlikView Script in QlikView

How to SQL Query into QlikView Script

Vinod — Sat, 16 Nov 2024 01:05:45 GMT

Hi All,

How to Write below SQL Query into QlikView Script in Different ways.

SELECT DLR_CD, BRC_CD,YEAR_MTH,

NVL((CASE WHEN (SUM(DECODE(KPI_VALUE,40,AMT_VAL_01))) = 0 THEN 0

ELSE

(SUM(DECODE(KPI_VALUE,9,AMT_VAL_01)) ) /

(SUM(DECODE(KPI_VALUE,40,AMT_VAL_01)))

END),0) AMT_VAL_01,

NVL((CASE WHEN (SUM(DECODE(KPI_VALUE,40,AMT_VAL_02))) = 0 THEN 0

ELSE

(SUM(DECODE(KPI_VALUE,9,AMT_VAL_02)) ) /

(SUM(DECODE(KPI_VALUE,40,AMT_VAL_02)))

END),0) AMT_VAL_02,

NVL((CASE WHEN (SUM(DECODE(KPI_VALUE,40,AMT_VAL_03))) = 0 THEN 0

ELSE

(SUM(DECODE(KPI_VALUE,9,AMT_VAL_03)) ) /

(SUM(DECODE(KPI_VALUE,40,AMT_VAL_03)))

END),0) AMT_VAL_03

FROM TB_RPT_RCOM202

WHERE KPI_VALUE IN (40,9)

AND YEAR_MTH = '201802'

and brc_cd='BL02A'

GROUP BY YEAR_MTH,DLR_CD, BRC_CD;

Thanks.

Vinod

Re: How to SQL Query into QlikView Script

Brett_Bleess — Wed, 08 Apr 2020 19:15:20 GMT

You should be able to copy/paste that into the QlikView Script Editor and run it after creating a Connect To string to connect to the source DB provided your Connector can handle all of the SQL calls you are making.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/SQL.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/CONNECT.htm

That should get you on the right track.

Regards,
Brett

Re: How to SQL Query into QlikView Script

usamabinsadiq — Wed, 08 Apr 2020 19:22:53 GMT

Hi,

you can achieve this by doing following :

TB_RPT_RCOM202: SQL SELECT DLR_CD, BRC_CD,YEAR_MTH, NVL((CASE WHEN (SUM(DECODE(KPI_VALUE,40,AMT_VAL_01))) = 0 THEN 0 ELSE (SUM(DECODE(KPI_VALUE,9,AMT_VAL_01)) ) / (SUM(DECODE(KPI_VALUE,40,AMT_VAL_01))) END),0) AMT_VAL_01, NVL((CASE WHEN (SUM(DECODE(KPI_VALUE,40,AMT_VAL_02))) = 0 THEN 0 ELSE (SUM(DECODE(KPI_VALUE,9,AMT_VAL_02)) ) / (SUM(DECODE(KPI_VALUE,40,AMT_VAL_02))) END),0) AMT_VAL_02, NVL((CASE WHEN (SUM(DECODE(KPI_VALUE,40,AMT_VAL_03))) = 0 THEN 0 ELSE (SUM(DECODE(KPI_VALUE,9,AMT_VAL_03)) ) / (SUM(DECODE(KPI_VALUE,40,AMT_VAL_03))) END),0) AMT_VAL_03 FROM TB_RPT_RCOM202 WHERE KPI_VALUE IN (40,9) AND YEAR_MTH = '201802' and brc_cd='BL02A' GROUP BY YEAR_MTH,DLR_CD, BRC_CD;

I hope this helps.

Regards,

Re: How to SQL Query into QlikView Script

usamabinsadiq — Wed, 08 Apr 2020 19:41:15 GMT

if my replay helped you then please do not forget to use the "Accept as Solution" button.