topic Re: Script help in QlikView

Script help

Thu, 08 Nov 2012 11:52:50 GMT

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

Re: Script help

Gysbert_Wassenaar — Thu, 08 Nov 2012 12:03:45 GMT

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

Re: Script help

Thu, 08 Nov 2012 12:11:29 GMT

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