Conditionally Show chart based on list box selection

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

I have list box with the following values.

Last Man Standing
OTC apps decom completed
OTC apps decom in progress
Remaining OTC apps
Remaining TSA's
TSA Exit Early In Progress
TSA Exited

I need to set a condition to show different charts when specific values are selected. For example, any time that Last Man Standing, Remaining TSA's, TSA Exit Early In Progress or TSA Exited are selected show chart 1.

If any combination for both charts is selected show both charts.

Anytime that any of these values (OTC apps decom completed, OTC apps decom in progress or Remaining OTC apps) are selected show chart 2.

I've been building the following condition, but it's very tedious and I'm sure that I'm missing possible combinations. There has to be a better way.

=if(isnull(GetFieldSelections([ITLT Dashboard Status]))

OR match(GetFieldSelections([ITLT Dashboard Status]),'TSA Exited','TSA Exit Early In Progress','Last Man Standing','Remaining TSA'&chr(39)&'s'
,'Last Man Standing, Remaining TSA'&chr(39)&'s'
,'Last Man Standing, TSA Exit Early In Progress'
,'Last Man Standing, TSA Exited'

,'Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress'
,'Remaining TSA'&chr(39)&'s, TSA Exited'

,'TSA Exit Early In Progress, TSA Exited'

,'Last Man Standing, Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress'
,'Last Man Standing, TSA Exit Early In Progress, TSA Exited'
,'Last Man Standing, Remaining TSA'&chr(39)&'s, TSA Exited'
,'Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress, TSA Exited'

,'Last Man Standing, Remaining TSA'&chr(39)&'s, TSA Exit Early In Progress, TSA Exited'

,'Last Man Standing, OTC apps decom completed'
,'Last Man Standing, OTC apps decom in progress'
,'Last Man Standing, Remaining OTC apps'

,'Remaining TSA'&chr(39)&'s, OTC apps decom completed'
,'Remaining TSA'&chr(39)&'s, OTC apps decom in progress'
,'Remaining TSA'&chr(39)&'s, Remaining OTC apps'

,'TSA Exit Early In Progress, OTC apps decom completed'
,'TSA Exit Early In Progress, OTC apps decom in progress'
,'TSA Exit Early In Progress, Remaining OTC apps'

Re: Conditionally Show chart based on list box selection

swuehl — Thu, 28 Jul 2016 22:05:32 GMT

I don't think you need to check for the explicite combinations, do you?

Maybe try like

= WildMatch( Concat(DISTINCT [ITLT Dashboard Status], '||'), '*TSA*', '*Last man standing*')

Re: Conditionally Show chart based on list box selection

brf10043 — Thu, 28 Jul 2016 22:17:15 GMT

That worked perfectly! Thank you for saving me hours of needless work!

topic Conditionally Show chart based on list box selection in QlikView

Conditionally Show chart based on list box selection

Re: Conditionally Show chart based on list box selection

Re: Conditionally Show chart based on list box selection