Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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",