topic Show expression based on listbox selections in QlikView

Show expression based on listbox selections

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Show expression based on listbox selections

sunny_talwar — Fri, 22 May 2020 14:49:25 GMT

Try this as your condition

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

Re: Show expression based on listbox selections

brunolelli87 — Fri, 22 May 2020 14:33:24 GMT

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!

Re: Show expression based on listbox selections

brunolelli87 — Fri, 22 May 2020 14:43:55 GMT

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!