How to supress NULL values in Text Object

[soha1902]

Hi All,

I have 3 fields Trainer, Trainee and Hours.

I am displaying all these fields in Text Object Using following expression:

=Concat(Trainer & '--' & chr(32) &

Trainee & '--' & chr(32) &

  Hours &

chr(13) & chr(13))

and it is working fine as I want but for some Trainee, Trainer is null so it is showing result like this:

-- Trainee1 -- 25

-- Trainee4 -- 30

My requirement is, I dont want to show those records where Trainer is not availabe. If I used any chart then simply we need to select Trainer dimension and then need to check "Suprees Null" but as per my requirement I need to display this in Text Box object only.

Please help me how to supress null values for Trainer as per above expression.

Thanks,

[PrashantSangle]

Hi,

Use If()

If(not isnull(Trainee),YourExpression)

Regards

[soha1902]

Its not working.

[#4]

if(not IsNull(Trainee),

(

Concat(Trainer & '--' & chr(32) &

Trainee & '--' & chr(32) &

  Hours &

chr(13) & chr(13))

))

[prajapatiamar38]

Hi,

Please find the attached Qvw below.

[jonathandienst]

Something like:

Concat(If(Len(Trainer) > 0, Trainer & '-- ' & Trainee & '-- ' & Hours), chr(13) & chr(13))

(chr(32) is a space, so I have included it in the literal strings)

[soha1902]

Hi,

As per your example I want following output:

Like this image, I want to display all the records in Text Object, where I need to remove first record because its not showing trainer name.

[PrashantSangle]

Hi,

Use

If(not isnull(Trainee) or not IsNull(Trainer) or not IsNull(Hours),YourExpression)

Regards

[jonathandienst · Accepted solution]

Something like:

Concat(If(Len(Trainer) > 0, Trainer & '-- ' & Trainee & '-- ' & Hours), chr(13) & chr(13))

(chr(32) is a space, so I have included it in the literal strings)

(Cannot upload app from here due to client security policies)

[prajapatiamar38]

Hi,

Do same as jonathan dienst is suggesting i think it is correct.