topic if, if else statement for load scripts in QlikView

if, if else statement for load scripts

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

Tryin to load this statement in load scripts...

if (Group=='B009') {'CONSOLIDATED INSURERS'} else if (Group=='T107') {'THE CONTINENTAL GROUP'} else {Account_Name}

Wed, 24 May 2017 14:12:36 GMT

Try following:

if (Group=='B009','CONSOLIDATED INSURERS',if (Group=='T107', 'THE CONTINENTAL GROUP', 'Account_Name')) as Name

Anonymous — Wed, 24 May 2017 14:15:06 GMT

Hello Tom,

Try this:

IF(Group=B009,[CONSOLIDATED INSURERS], if (Group=T107 ,['THE CONTINENTAL GROUP] , [Account_Name]))

Regards

Jacek

vishsaggi — Wed, 24 May 2017 15:09:14 GMT

Using Jacek expression may be use quotes around the Group values like

if (Group = 'B009', 'CONSOLIDATED INSURERS',

if (Group = 'T107', 'THE CONTINENTAL GROUP', 'Account_Name')) as Name

vishsaggi — Thu, 25 May 2017 14:15:46 GMT

Did you get what you looking for?

Anonymous — Thu, 25 May 2017 14:33:15 GMT

Yes I did...Thank you very much

vishsaggi — Thu, 25 May 2017 15:20:18 GMT

Can you close the thread marking appropriate responses as correct or Helpful.

Thanks
V.

omkarvamsi — Thu, 25 May 2017 15:32:43 GMT

Hi,

please try below script

if (Group='B009', 'CONSOLIDATED INSURERS',

if (Group='T107','THE CONTINENTAL GROUP','Account_Name') as ALIASNAME

Note:

if Account_Name is a field it should not be enclosed in the single quotations.

Only strings are to be placed in between in singular quotations.

Regards