Show expression based on listbox selections

[brunolelli87]

Hello guys,

How can I show some expressions on the chart based on the user's selection of items on a Listbox?

The ListBox is using the fieldName called NDIC, and I'm currently lysing the following conditional expression:

NDIC='DOLLAR'

But, as you can see below, this expression is working only if the user selects just DOLLAR, otherwise, if he selects DOLLAR and EURO, the system is not showing the DOLLAR and EURO lines...

Please, check the pictures below:

Nothing selected

Dollar selected:

Euro, just EURO, selected

Both selected. 
I was expecting to see the blue, and both YELLOW and RED lines...
how can I do it?

Thanks
Bruno

[sunny_talwar · Accepted solution]

Try this as your condition

SubStringCount('|' & GetFieldSelections(NDIC, '|,|') & '|', '|DOLLAR|') = 1

[brunolelli87]

Hello,

Thanks for your help, but it's now working.

It seems we have an issue with the expression:

And no matter what I select (or not), the DOLLAR line is always visible!

[brunolelli87 · Accepted solution]

Hello,

Your help was correct... there was just a mistyping with parentheses...

The correct formula is:

SubStringCount('|' & GetFieldSelections(NDIC, '|,|') & '|', '|DOLLAR|') = 1

Thank you os much!