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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script help

new to qlikview can someone help with debuging scripts below:

If (POL_CRT_USER = 263 AND POL_STANNIC_POLICY is NOT NULL THEN 1,

  If (POL_CRT_USER <> 263,'1') ) as InterfaceUser,

and scrit 2:

             If (CLI_COMP = Y, 'CLI_COMP_NAME',

               If (CLI_LANG_CDE = 1,'RTRIM(TIT_DESC)',

              
If (CLI_LANG_CDE = 1,'CLI_INIT',

               
If (CLI_LANG_CDE = 1,'RTRIM(CLI_SURN)','TIT_ARAB_DESC','CLI_INIT','CLI_SURN')))) as Name

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Not exactly sure what your trying to do, but try these:

If (POL_CRT_USER = 263 AND len(trim(POL_STANNIC_POLICY)) > 0,  1, If (POL_CRT_USER <> 263,1) ) as InterfaceUser,

If (CLI_COMP = 'Y', CLI_COMP_NAME,

    If (CLI_LANG_CDE = 1, RTRIM(TIT_DESC) & ' ' & RTRIM(CLI_SURN) , TIT_ARAB_DESC & ' ' &  CLI_INIT & ' ' & CLI_SURN)) as Name


talk is cheap, supply exceeds demand
Not applicable
Author

hi the orignal sql script is

casE WHEN POL_CRT_USER" = 263 AND POL_STANNIC_POLICY IS NOT NULL THEN 1

//                  WHEN POL_CRT_USER <> 263 THEN 1

//             END As "InterfaceUser",