Conditional show

[#1]

If I conditionally show a line on a chart using this expression

GetFieldSelections(DESK)='BANK CAPITAL - GSL'

It would only show when that value is selected in the DESK field. However, I also want it to show when no value is selected in the DESK field and no value is selected in another fields called SECTOR. How would I amend the expression?

[SunilChauhan]

GetFieldSelections(DESK)='BANK CAPITAL - GSL'  or getselectedcount(DESK)=0

in layout of object properties

hope this helps

[#3]

That doesn't take into account the SECTOR field though.

If no selections are made in the DESK field but selections are made in the SECTOR field, your logic above would mean it would still appear. I need to ensure it does NOT appear when this happens

[its_anandrjs · Accepted solution]

In Layout property of the chart you can try with

If(  ( GetFieldSelections(DESK)='BANK CAPITAL - GSL'  or GetFieldSelections(DESK)=0 And GetFieldSelections(SECTOR)=0 ),1,0)

[#5]

Thanks Anand

what would be the syntax for multiple values

GetFieldSelections(DESK)='BANK CAPITAL - GSL' AND 'CDS HY'

?????