topic Re: requirement on if condition in QlikView

requirement on if condition

Wed, 25 Nov 2020 16:16:04 GMT

hi frnds

if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',

if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',

if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',

if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',

if([BTS Contact]='Solution Manager','solution_manager_name',

if([BTS Contact]='Project Manager','project_manager')))))) as contact

it is working in frontend object level but if i apply back end it is not working

here the condition is :"

if([BTS Contact]='Solution Manager' then bring data solution_manager_name field;

if([BTS Contact]='Project Manager then bring data roject_manager' field;

Thanks,

siddiq

sunny_talwar — Wed, 04 May 2016 19:36:38 GMT

Thu, 05 May 2016 17:59:54 GMT

Thanks sunny now i got it

SunilChauhan — Fri, 06 May 2016 06:13:25 GMT

Can you use field name without single quote

if([BTS Contact]='Manager' and Portfolio ='US Pharma','Kelly ',

if([BTS Contact]='Manager' and Portfolio ='Corporate','’Tasha ',

if([BTS Contact]=' Manager' and Portfolio ='MDS','Juli ',

if([BTS Contact]='Manager' and Portfolio ='MTS (McK Tech Solutions)','Terri ',

if([BTS Contact]='Solution Manager',Solution_manager_name,

if([BTS Contact]='Project Manager',project_manager)))))) as contact