Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Filter table as per listbox_selections

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.

Capture.GIF

Thanks

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: Filter table as per listbox_selections

Used calculated dimension and suppressed null values :

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

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

Capture.GIF

View solution in original post

7 Replies
Highlighted
Champion III
Champion III

Re: Auto populate Search box with *listbox_selections*

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?

Highlighted
Creator
Creator

Re: Filter table as per listbox_selections

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

Highlighted

Re: Filter table as per listbox_selections

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Champion III
Champion III

Re: Filter table as per listbox_selections

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

Highlighted
Creator
Creator

Re: Filter table as per listbox_selections

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

Highlighted
Partner
Partner

Re: Filter table as per listbox_selections

Hi,

Try adding the "Parameter" field in the table.

It will filter the table based on the selection.


Regards

Highlighted
Creator
Creator

Re: Filter table as per listbox_selections

Used calculated dimension and suppressed null values :

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

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

Capture.GIF

View solution in original post