topic Re: expr in QlikView

expr

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

Hi All,

Hi in the script level iam trying to replace the null va;ues in Dept by brand , can anyone suggest if below statement is correct ?

if(IsNull(Dept),'brand',Dept),

Re: expr

tresB — Fri, 17 Mar 2017 06:22:56 GMT

Try like:

if(IsNull(Dept),'brand',Dept) as Fieldname

Or, better to deal with not-null spaces or other invisible characters try like:

if(Len(Trim(Dept))=0,'brand',Dept) as Fieldname

Assuming Dept is a field and you want it's value to be called as 'brand'.

Re: expr

smilingjohn — Fri, 17 Mar 2017 06:34:34 GMT

Yes Dept is a field and when ever there is null value in Dept it should be named as brand, if no null then as it is .

Re: expr

tresB — Fri, 17 Mar 2017 06:36:34 GMT

Have you tried the above solutions?

Re: expr

nitin_01 — Fri, 17 Mar 2017 07:21:56 GMT

Hi Tresesco,

if(Len(Trim(Dept))>0,'brand',Dept) as Fieldname

with all respect, i'am perplexed with above condition that would give a desired output.

That shud be '=0' or '>0' ?

Regards,

Nitin.

Re: expr

tresB — Fri, 17 Mar 2017 07:25:36 GMT

You are spot on. Corrected my post above.

Re: expr

nitin_01 — Fri, 17 Mar 2017 07:30:19 GMT

hahah...

we follow you..:)

Regards,

Nitin.

Re: expr

aapurva09 — Fri, 17 Mar 2017 07:34:53 GMT

Hi,

try this:

if(len(Dept)<=0,'brand',Dept)

Thanks

Re: expr

Fri, 17 Mar 2017 07:50:10 GMT

Try this If(len(Dept)=0,Brand,Dept) as NewField,

Let me know if this is working else I will provide other solution.

Thanks

jaydeep

Re: expr

smilingjohn — Fri, 17 Mar 2017 11:29:42 GMT

Hi tressco

you first statement worked fine

if(IsNull(Dept),'brand',Dept) as Fieldname