topic Re: Replace null dimension value with string in QlikView

Replace null dimension value with string

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In the below image i need to replace '-' with 'EMP_Not _Available' and it is an dimension and the change should reflect only that dimension alone.

Re: Replace null dimension value with string

nareshthavidishetty — Tue, 29 Nov 2016 18:42:39 GMT

Hi,

Here is the image.

Thanks..

Re: Replace null dimension value with string

MK_QSL — Tue, 29 Nov 2016 18:43:26 GMT

What is the dimension / calculated dimension you have used?

Re: Replace null dimension value with string

sunny_talwar — Tue, 29 Nov 2016 18:44:26 GMT

May be like this:

If(Len(Trim(Dimension)) = 0, 'EMP_Not _Available', Dimension)

Re: Replace null dimension value with string

nareshthavidishetty — Tue, 29 Nov 2016 18:54:36 GMT

Hi Sunny,

This is the dimension

=if([Transaction Type]='S',if(isnull(Employee_Name1),Lawson_EmployeeName1,Employee_Name1))

Thanks..

Re: Replace null dimension value with string

sunny_talwar — Tue, 29 Nov 2016 18:56:59 GMT

May be this

If(Len(Trim(If([Transaction Type]='S', If(IsNull(Employee_Name1), Lawson_EmployeeName1, Employee_Name1)))) = 0, 'EMP_Not _Available', If([Transaction Type]='S', If(IsNull(Employee_Name1), Lawson_EmployeeName1, Employee_Name1)))

Re: Replace null dimension value with string

nareshthavidishetty — Tue, 29 Nov 2016 19:01:31 GMT

Thanks Sunny...awesome

Re: Replace null dimension value with string

MK_QSL — Tue, 29 Nov 2016 19:01:34 GMT

=if([Transaction Type]='S',

if(Not isnull(Employee_Name1), Employee_Name1,

If(IsNull(Lawson_EmployeeName1),'Emp_Not_Available',Lawson_EmployeeName1)))

Re: Replace null dimension value with string

rupamjyotidas — Tue, 29 Nov 2016 19:04:01 GMT

Maybe This

ALT(if([Transaction Type]='S',if(isnull(Employee_Name1),Lawson_EmployeeName1,Employee_Name1)) ,'EMP_Not _Available',) as Empfield

Re: Replace null dimension value with string

sunny_talwar — Tue, 29 Nov 2016 19:05:12 GMT

Recently learnt that ALT() only work with numbers. With text, the above expression will always spit out 'EMP_Not_Available'

Re: Replace null dimension value with string

rupamjyotidas — Tue, 29 Nov 2016 19:06:48 GMT

Ah, Interesting. Let me check . Thanks