topic How to supress NULL values in Text Object in QlikView

How to supress NULL values in Text Object

soha1902 — Tue, 26 May 2015 05:34:12 GMT

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,

Re: How to supress NULL values in Text Object

PrashantSangle — Tue, 26 May 2015 05:44:20 GMT

Hi,

Use If()

If(not isnull(Trainee),YourExpression)

Regards

Re: How to supress NULL values in Text Object

soha1902 — Tue, 26 May 2015 05:52:57 GMT

Its not working.

Re: How to supress NULL values in Text Object

Tue, 26 May 2015 05:57:02 GMT

if(not IsNull(Trainee),

(

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

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

Hours &

chr(13) & chr(13))

))

Re: How to supress NULL values in Text Object

prajapatiamar38 — Tue, 26 May 2015 06:04:43 GMT

Hi,

Please find the attached Qvw below.

Re: How to supress NULL values in Text Object

jonathandienst — Tue, 26 May 2015 06:15:23 GMT

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)

Re: How to supress NULL values in Text Object

soha1902 — Tue, 26 May 2015 06:22:18 GMT

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.

Re: How to supress NULL values in Text Object

PrashantSangle — Tue, 26 May 2015 06:26:54 GMT

Hi,

Use

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

Regards

Re: How to supress NULL values in Text Object

jonathandienst — Tue, 26 May 2015 06:28:01 GMT

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)

Re: How to supress NULL values in Text Object

prajapatiamar38 — Tue, 26 May 2015 06:35:33 GMT

Hi,

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

Re: How to supress NULL values in Text Object

Anonymous — Tue, 26 May 2015 06:46:06 GMT

Hi Soha,

Find Attached solution.

Hope this will solve your problem.

Thanks

BKC

Re: How to supress NULL values in Text Object

soha1902 — Tue, 26 May 2015 07:57:18 GMT

Hi Jonathan,

How we use Distinct keyword inside this expression. In my application I have repetion of multiplwe values.

can you please help me.

Thanks..