Displaying charts based on list box selection

[parul_mehta]

Hi,

I have a requirement wherein I need to display charts based on values selected in list box

List box material has 9 values

I select A, Chart A should display the required data , charts B, C and D should dsplay nothing

AB , Both charts A and B should get activated and display required data , charts C and D should dsplay nothing

ABC Charts A, B and C should get activated and display required data, charts  D should dsplay nothing

ABCD , Charts A B C d should get activated, and display the required data

Maximum of 4 values can be selected in Listbox, and corresponding charts to display data

Material		Chart A					Chart C
A
B
C
D
E
F		Chart B					Chart D
G
H
I

[Anonymous]

Use a calculation condition.

For chart

=wildmatch(GetFieldSelections(Material),'*A*') and GetSelectedCount(Material)<>0

Change A to for each chart value.

[Frank_Hartmann]

attached sample might be helpful

[Sergey_Shuklin]

Hello, Parul!

You can use a FindOneOf() and GetFieldSelections() functions to solve that task.

Please, find an attachement below. Hope it's what you lookin' for!  

[Anonymous]

Putting in expression didn't even occur to me.  Nice implementation.

I do suspect the calculation condition would perform a little bit better.  Plus it keeps your expression(s) cleaner.

And I think you would really only need =wildmatch(GetFieldSelections(Material),'*A*') (not what i had earlier).

The other bonus with calculation condition is that then you can go into the Error Messages and customize the message to say whatever you want.  Like "Chart will populate when selected in filter".

[parul_mehta]

Thanks for the example qvw.,

I have around 80000 materials, and would like to display any of  the 4 field selections in the chart, not hardcoded values

the first value selected ( could be at the 24th row ) should be displayed in chart A

second value selected ( could be elsewhere , say the 50th value ) that should display in chart B

third value selected ( at any row ) should display in chart C

fourth value selected, ( say at row 108 ) should display in chart D

if you could please help with this.

[parul_mehta]

Please provide inputs