I wanted to Convert Sql Query to Qlik Sense

kartik — Tue, 08 Feb 2022 08:48:00 GMT

This is the query. Actually, I need to convert this SQL logic to Qlik sense

EQRY_PRESENT_CAR_YN AS PRESENT_CAR_YN,

EQRY_P_MODL_YEAR as MDL_YEAR,

EQRY_EXCHG_YN AS EXCHANGE,

EQRY_EXCHG_SRC_CODE AS EXCHANGE_CNL_CD,

FNC_GET_CODE_NAME ('DSC0006', EQRY_EXCHG_SRC_CODE,'en') AS EXCHANGE_CNL, - this has done but how can I add this too in the whole logic

EQRY_EVAL_YN AS EVALUATION,

EQRY_EXPCT_PRICE AS EXPECTED_PRICE,

EQRY_QUOTD_PRICE AS QUOTED_PRICE,

EQRY_EXCH_DN AS EXCHANGE_DN,

EQRY_FINAL_BP AS BUYING_PRICE,

(SELECT A.MAKE_FULL_DSCTN FROM SAL_UCMAKE_TB A WHERE A.MAKE_MAKER_CODE=EQRY_MAKER_CODE ) AS OEM,

(SELECT B.MODL_FULL_DSCTN FROM SAL_UCMODL_TB B WHERE B.MODL_MODEL_CODE=EQRY_EXCHG_MODEL_CODE AND B.MODL_MAKER_CODE=EQRY_MAKER_CODE) AS MODEL

and the table used in this is this

Enquiry:

LOAD

"EQRY_EXCHG_YN" ,
"EQRY_ENQRY_NO",
"EQRY_EXCHG_SRC_CODE",
"EQRY_EXPCT_PRICE" ,
"EQRY_QUOTD_PRICE" ,
"EQRY_PRESENT_CAR_YN" ,
"EQRY_P_MODL_YEAR" ,
"EQRY_EVAL_YN" ,
"EQRY_EXCH_DN" ,
"EQRY_FINAL_BP" ,
"EQRY_EXCHG_MODEL_CODE",
"EQRY_MAKER_CODE";
SQL SELECT "EQRY_EXCHG_YN",
"EQRY_EXCHG_SRC_CODE",
"EQRY_ENQRY_NO",
"EQRY_EXPCT_PRICE",
"EQRY_QUOTD_PRICE" ,
"EQRY_PRESENT_CAR_YN",
"EQRY_P_MODL_YEAR",
"EQRY_EVAL_YN",
"EQRY_EXCH_DN",
"EQRY_FINAL_BP",
"EQRY_EXCHG_MODEL_CODE",
"EQRY_MAKER_CODE"
FROM DMSDBA."CRM_SCEQRY_TB";

uc_maker:
LOAD

"MAKE_MAKER_CODE",
"MAKE_FULL_DSCTN" as OEM;
SQL SELECT "MAKE_MAKER_CODE",
"MAKE_FULL_DSCTN"
FROM DMSDBA."SAL_UCMAKE_TB";

Uc_model:
LOAD

"MODL_MAKER_CODE",
"MODL_MODEL_CODE",
"MODL_FULL_DSCTN" as MODEL;
SQL SELECT "MODL_MAKER_CODE",
"MODL_MODEL_CODE",
"MODL_FULL_DSCTN"
FROM DMSDBA."SAL_UCMODL_TB";

thanks and regards,

kartik

Re: I wanted to Convert Sql Query to Qlik Sense

kartik — Mon, 07 Feb 2022 06:34:05 GMT

Anyone knows how can I make OEM column in Qlik using SQL query?

Re: I wanted to Convert Sql Query to Qlik Sense

chris_djih — Mon, 07 Feb 2022 14:55:54 GMT

Try to elaborate on the concepts of Mapping Load and Applymap.
I think this is exactly what you need.

topic I wanted to Convert Sql Query to Qlik Sense in App Development

I wanted to Convert Sql Query to Qlik Sense

Re: I wanted to Convert Sql Query to Qlik Sense

Re: I wanted to Convert Sql Query to Qlik Sense