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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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",