topic Re: Table filtering in QlikView

Table filtering

Tue, 29 Mar 2016 09:03:04 GMT

Hi there,

I have the below on my dashboard.

Essentially, the Ref field is the project ID.

The dependent field should show the project ID that this particular project is dependent on. For example, Project 2 is dependent on project 1 completing.

When I click on the "Dependent" column, I'd like to be able to filter by ref, not by the contents of that column. So, if I select Project 1 from the dependent column, it should filter ref, to show Project 1.

Is this possible?

Re: Table filtering

Gysbert_Wassenaar — Tue, 29 Mar 2016 09:13:04 GMT

Perhaps with Select in Field actions assigned to the OnSelect field trigger of the Dependent on field. You can find the triggers on the Triggers tab of the Document Properties window. The field to select in would be ref and the value would be =only([Dependent on])

Re: Table filtering

Tue, 29 Mar 2016 09:24:18 GMT

Thank you - very helpful.

I've got a bit stuck here - can you advise?

Re: Table filtering

Gysbert_Wassenaar — Tue, 29 Mar 2016 09:27:45 GMT

You're selecting in the field [dependent], so that's the field you should select for the field even trigger. You want to make a selection in the ref field so that's the field name you should use for the Field settting in the Select in Field action. the Search string value should be the value that you select in the dependent field, i.e. =only(dependent)

Re: Table filtering

Wed, 30 Mar 2016 12:38:31 GMT

Hi there,

Sorry, it doesn't seem to be working

Re: Table filtering

Gysbert_Wassenaar — Wed, 30 Mar 2016 12:44:50 GMT

Please post a small qlikview document that illustrates the problem.

Re: Table filtering

Wed, 30 Mar 2016 12:48:03 GMT

I can't, I currently am evaluating Qlikview, so only have the personal edition

Re: Table filtering

Gysbert_Wassenaar — Wed, 30 Mar 2016 12:51:14 GMT

I don't see how that makes it impossible to create a small qlikview document and upload it here.