Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
GetFieldSelections(DESK)='BANK CAPITAL - GSL' or getselectedcount(DESK)=0
in layout of object properties
hope this helps
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
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)
Thanks Anand
what would be the syntax for multiple values
GetFieldSelections(DESK)='BANK CAPITAL - GSL' AND 'CDS HY'
?????