Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
kartik
Contributor III
Contributor III

How to write this query of SQL in Qlik sense

I have this SQL Logic.  FNC_GET_CODE_NAME ('DSC0006', EQRY_EXCHG_SRC_CODE,'en') AS EXCHANGE_CNL

, and the query for this logic is given below. How can I write it in Qlik sense ??

SELECT

        NVL(T2.CMM_CODE_TXT,

        T1.CMM_CODE_NAME) AS V_CODE_NAME

   FROM CMM_CMCD_TB T1 LEFT OUTER JOIN CMM_CMCDLG_TB T2 ON T1.CMPN_NO = T2.CMPN_NO

    AND T1.CORP_NO = T2.CORP_NO

    AND T1.CMM_GRP_CODE = T2.CMM_GRP_CODE

    AND T1.CMM_CODE = T2.CMM_CODE

    AND T2.LANG_CODE = 'en'

  WHERE T1.CMPN_NO = 'K'

    AND T1.CORP_NO = 'A10VA'

    AND T1.CMM_GRP_CODE= 'DSC0006'

    AND T1.CMM_CODE= '01';

and the table used in this is 

T1:
LOAD

"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME"
FROM DMSDBA."CMM_CMCD_TB";


T2:

LOAD

"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT"
FROM DMSDBA."CMM_CMCDLG_TB";

 

Labels (3)
1 Solution

Accepted Solutions
anat
Master
Master

T1:
LOAD 

"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME"
FROM DMSDBA."CMM_CMCD_TB"

where

CMPN_NO = 'K'

    AND CORP_NO = 'A10VA'

    AND CMM_GRP_CODE= 'DSC0006'

    AND CMM_CODE= '01';

;

join(T1)
T2:

LOAD 

"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT"
FROM DMSDBA."CMM_CMCDLG_TB" where LANG_CODE = 'en';

View solution in original post

3 Replies
anat
Master
Master

T1:
LOAD 

"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"CMM_CODE_NAME"
FROM DMSDBA."CMM_CMCD_TB"

where

CMPN_NO = 'K'

    AND CORP_NO = 'A10VA'

    AND CMM_GRP_CODE= 'DSC0006'

    AND CMM_CODE= '01';

;

join(T1)
T2:

LOAD 

"CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT";
SQL SELECT "CMPN_NO",
"CORP_NO",
"CMM_GRP_CODE",
"CMM_CODE",
"LANG_CODE",
"CMM_CODE_TXT"
FROM DMSDBA."CMM_CMCDLG_TB" where LANG_CODE = 'en';

kartik
Contributor III
Contributor III
Author

Thanks man!!! Super'b.. 

I also have this query

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";

 

kartik
Contributor III
Contributor III
Author

Anyone who knows, pls help.