Lable logic is not working

[arethaking]

Hi All,

My Lable logic is not working in Pivot Table.

This is the condition.

=if(Flag='A' and [OrgName]='RX' and [Org Customer]='Yes',
'Score',
if(Flag='B' and [OrgName]='RX' and [Org Customer]='Yes',
'Score',
if(Flag='C' and [OrgName]='RX' and [Org Customer]='Yes',
'Score',
if(Flag='D' and [OrgName]='RX' and [Org Customer]='Yes',
'Rank'
))))

Expected Output:

Present output:

My Source Data

Data:
LOAD * INLINE [
Org Customer,CustName,Flag,OrgName,Ascore,Bscore,Cscore,Dscore
Yes,Cust1,B,A1,Good,Good,Good,1st
Yes,Cust1,B,A2,Average,Average,Average,2nd
Yes,Cust2,B,A1,Outstanding,Outstanding,Outstanding,1st
Yes,Cust2,B,A2,Average,Average,Average,2nd
Yes,Cust1,B,RX,Average,Average,Average,1st
Yes,Cust1,A,A1,Good,Good,Good,2nd
Yes,Cust1,A,A2,Average,Average,Average,Not Ranked
Yes,Cust1,A,A3,Good,Good,Good,1st
Yes,Cust2,A,A1,Good,Good,Good,Not Ranked
Yes,Cust2,A,A2,Average,Average,Average,1st
Yes,Cust2,A,A3,Outstanding,Outstanding,Outstanding,Not Ranked
Yes,Cust1,A,RX,Average,Average,Average,1st
Yes,Cust1,A,RX,Average,Average,Average,Not Ranked
Yes,Cust2,C,,Good,Good,Good,1st
Yes,Cust1,C,RX,Average,Average,Average,1st
Yes,Cust1,D,A14,Good,Good,Good,1st
Yes,Cust1,D,A15,Good,Good,Good,2nd
Yes,Cust1,D,A1,Average,Average,Average,1st
Yes,Cust1,D,A2,Outstanding,Outstanding,Outstanding,2nd
Yes,Cust1,D,A3,Average,Average,Average,1st
Yes,Cust1,D,RX,Average,Outstanding,Outstanding,2nd
];

[qlikviewwizard]

Create a field for Score and Rank values as Score_Rank .

Data:

LOAD * ,if(Wildmatch(Flag,'A','B','C') AND OrgName='RX' and [Org Customer]='Yes', 'Score',

if(Flag='D' AND OrgName='RX' and [Org Customer]='Yes','Rank')) as Score_Rank INLINE [

Org Customer,CustName,Flag,OrgName,Ascore,Bscore,Cscore,Dscore

Yes,Cust1,A,RX,Average,Average,Average,1st

Yes,Cust1,B,RX,Average,Average,Average,1st

Yes,Cust1,C,RX,Average,Average,Average,1st

Yes,Cust1,D,A1,Average,Average,Average,1st

Yes,Cust1,D,A3,Average,Average,Average,1st

Yes,Cust1,B,A2,Average,Average,Average,2nd

Yes,Cust1,A,A2,Average,Average,Average,Not Ranked

Yes,Cust2,D,RX,Average,Average,Average,1st

Yes,Cust2,B,A2,Average,Average,Average,2nd

Yes,Cust1,D,RX,Average,Outstanding,Outstanding,2nd

Yes,Cust1,A,A3,Good,Good,Good,1st

Yes,Cust1,B,A1,Good,Good,Good,1st

Yes,Cust1,A,A1,Good,Good,Good,2nd

Yes,Cust1,D,A2,Outstanding,Outstanding,Outstanding,2nd

Yes,Cust2,B,A1,Outstanding,Outstanding,Outstanding,1st

Yes,Cust2,A,A3,Outstanding,Outstanding,Outstanding,Not Ranked

];