Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Conditionally Show chart based on list box selection

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'

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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*')

View solution in original post

2 Replies
swuehl
MVP
MVP

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*')

View solution in original post

brf10043
Creator
Creator
Author

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