Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Used calculated dimension and suppressed null values :
=if(match(Parameter,name1),name1,
if(match(Parameter,name2),name2))
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?
No, it can be anything. I have re-framed the question.
There is no link between Parameter and Parameter_Combo? You want to be forcibly without Link from two tables?
What is the relation between Parameter and ParameterCombo? What are the valid values you want to see when you select in parameter field?
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
Hi,
Try adding the "Parameter" field in the table.
It will filter the table based on the selection.
Regards
Used calculated dimension and suppressed null values :
=if(match(Parameter,name1),name1,
if(match(Parameter,name2),name2))