Filter table as per listbox_selections

[kinjal1645]

Hi,

I need help in attached sample file.

Actual application has far more data.

Kindly suggest a solution which filters data in Parameter_combo chart as per selections in Parameter list box.

When I select test3 in "Parameter" list box then "Parameter_combo" table should display only test3 records.

It would be good if it is done without data model change.

Thanks

[vishsaggi]

I doubt if you can do anything like that. Just curious to know what is the purpose of showing your selections in Search object? Any specific reason?

[kinjal1645]

No, it can be anything. I have re-framed the question.

[Anil_Babu_Samineni]

There is no link between Parameter and Parameter_Combo? You want to be forcibly without Link from two tables?

[vishsaggi]

What is the relation between Parameter and ParameterCombo? What are the valid values you want to see when you select in parameter field?

[Anonymous]

Try Field event triggers

Settings > Document Properties > Triggers

Field Event Triggers and select th Parameter field and 

onselect and onchange you do the SELECT FIELD in Parameter Combo name1 and name2

[sudhirpkuwar]

Hi,

Try adding the "Parameter" field in the table.

It will filter the table based on the selection.

Regards

[kinjal1645 · Accepted solution]

Used calculated dimension and suppressed null values :

=if(match(Parameter,name1),name1,

if(match(Parameter,name2),name2))