topic Re: Filter table as per listbox_selections in QlikView

Filter table as per listbox_selections

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

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 — Wed, 18 Apr 2018 21:24:32 GMT

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 — Wed, 18 Apr 2018 21:34:14 GMT

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

Anil_Babu_Samineni — Thu, 19 Apr 2018 00:09:39 GMT

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

vishsaggi — Thu, 19 Apr 2018 02:10:58 GMT

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

Anonymous — Thu, 19 Apr 2018 02:33:11 GMT

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 — Thu, 19 Apr 2018 05:25:33 GMT

Hi,

Try adding the "Parameter" field in the table.

It will filter the table based on the selection.

Regards

kinjal1645 — Thu, 19 Apr 2018 22:28:58 GMT

Used calculated dimension and suppressed null values :

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

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