Is there a way to use pick and match for the below KPI expression

[aarav021]

If(GetSelectedCount(MONTH)=0 and GetSelectedCount(QUARTER)=1,

if(GetSelectedCount(Hospital_NAME)=0,

Also is there a way we can use to define these expression in load editor and use pick and match in the KPI Expression. 

Please help me regarding this !

[vinieme12]

1) Using Match /Wildmatch you would compare values in One field only

2) this expression is not checking any field values but just verifying selections! is there more to ?

[aarav021]

If(GetSelectedCount(MONTH)=0 and GetSelectedCount(QUARTER)=1,

if(GetSelectedCount(Hospital_NAME)=0,

((count({<Hospital_NAME={'xyz'}>}Hospital_NAME)/
count({1}if(QUARTER_NAME=QuarterName(QuarterName(QUARTER_NAME)-1) and Hospital_NAME='xyz',Hospital_NAME))) -1)
,
((count(Hospital_NAME)/
count({1}if(QUARTER_NAME=QuarterName(QuarterName(QUARTER_NAME)-1),Hospital_NAME))) -1)

)

)

This is full expression I want to use pick and match or wildmatch to increase performance.. Is it possible in this expression ? 

[vinieme12]

you can look at optimizing the below expression by using set analysis instead of if()

count({1}if(QUARTER_NAME=QuarterName(QuarterName(QUARTER_NAME)-1) and Hospital_NAME='xyz',Hospital_NAME))) -1)

to below

count({1<

QUARTER_NAME ={'$(=QuarterName(QuarterName(QUARTER_NAME)-1))'}

,Hospital_NAME={'xyz' }

>}  Hospital_NAME )

[aarav021]

Its giving syntax error. Will there be {1} or just 1 ?

[vinieme12]

can you post a snapshot of the edit expression window ; so i can see exactly what's causing the error