topic Replace with IsNull or '' in QlikView

Replace with IsNull or ''

Mon, 21 May 2012 13:12:04 GMT

I am currently concatenating two fields and adding a space

trim([Opportunity owner Firstname]& ' ' &[Opportunity owner Surname]) as [Opportunity Owner],

I'd also like to if either the Firstname or Surname is '' or Null to null the [Opportunity Owner],

Could someone point me in the right direction please?

Replace with IsNull or ''

SunilChauhan — Mon, 21 May 2012 13:20:52 GMT

(

if(isnull([Opportunity owner FisrtName]),' ',[Opportunity owner FisrtName])

& ' ' &

if(isnull([Opportunity owner Surname]),' ',[Opportunity owner Surname]))

you can also change ' ' to any thing else like 'NULL'

hope this helps

Replace with IsNull or ''

Mon, 21 May 2012 13:22:25 GMT

Will this remove the space i have added in the concatenate?

Replace with IsNull or ''

SunilChauhan — Mon, 21 May 2012 13:24:36 GMT

in that case use below code

trim(

if(isnull([Opportunity owner FisrtName]),' ',[Opportunity owner FisrtName])

if(isnull([Opportunity owner Surname]),' ',[Opportunity owner Surname]))

Replace with IsNull or ''

jagannalla — Mon, 21 May 2012 13:29:53 GMT

Hello,

Try this code. Hope it helps you.

If([Opportunity owner Firstname]& ' ' &[Opportunity owner Surname]='',Null(),Trim([Opportunity owner Firstname]& ' ' &[Opportunity owner Surname])) as [Opportunity Owner]

Replace with IsNull or ''

Mon, 21 May 2012 13:34:02 GMT

Hi Lewis,

try with this:

if (IsNull([Opportunity owner Firstname]) or trim([Opportunity owner Firstname])='' or IsNull([Opportunity owner Surname]) or trim([Opportunity owner Surname])='' , null(), trim([Opportunity owner Firstname]) & ' ' & trim([Opportunity owner Surname])) as [Opportunity Owner]

Replace with IsNull or ''

Mon, 21 May 2012 14:06:31 GMT

Excellent, thats worked perfectly... Thank you all for your help!