topic Re: RE:IF again in QlikView

RE:IF again

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

Hi all,

I have samll error in below code.

if(vServerName='1-2-3-4','1-2-3-4',if(vServerName='1-0-3-4','1-0-3-4',if (vServerName = 'ABC','CBD' ))) as vServerName

end if;

can anyone give suggestions on this

Thanks in advance.est

Chanty

sunny_talwar — Tue, 19 Apr 2016 12:23:58 GMT

Is this within the LOAD statement? If it is, I don't think you need a ENDIF

If(vServerName = '1-2-3-4','1-2-3-4',

if(vServerName = '1-0-3-4','1-0-3-4',

If(vServerName = 'ABC', 'CBD'))) as vServerName

tresB — Tue, 19 Apr 2016 12:26:02 GMT

May be you just need to define a variable like:

Let vServerName=ComputerName();

And then use this variable like:

IF vServerName='ABC' Then

Do this...

Else IF vServerName = 'XYZ' Then

Do.. this2

Else IF vServerName= 'Others' Then

Do ..that

End IF

Chanty4u — Tue, 19 Apr 2016 13:43:58 GMT

Thanks sunny &Tre

jagan — Tue, 19 Apr 2016 14:18:29 GMT

Hi,

You can simply use this

if(vServerName= 'ABC','CBD', If(Mixmatch(vServerName, '1-2-3-4', '1-0-3-4'), vServerName)) as vServerName

Regards,

Jagan.