topic how establish relationship between 2 sheets in QlikView

how establish relationship between 2 sheets

Tue, 07 May 2013 17:02:59 GMT

Example:

A document contains 2 sheets (Sales and Receibables)

On Sales sheet , there is an object (simple table or list selection) that contains the customer's name.

On Receibables sheet , there is another object also contains the customer's name.

I want to select a customer in the sales sheet and that the Receibables sheet is filtered by the selected client

Could someone give me an idea of cone do.

Thanks for your help

Re: how establish relationship between 2 sheets

Gysbert_Wassenaar — Tue, 07 May 2013 17:16:48 GMT

If both objects use the same customer field then a selection on one sheet will be reflected in the object on the other sheet. The selection is made in the same field so any object displaying that field shows the same values.

Re: how establish relationship between 2 sheets

Tue, 07 May 2013 17:36:06 GMT

thanks, Gysbert.

Each sheet query different tables.

Client_name field exists in more than one table.

When I select a customer in the Sales sheet, the Receibables sheet is filtered, but do not know how to reset to display again all clients.

Re: how establish relationship between 2 sheets

Gysbert_Wassenaar — Tue, 07 May 2013 17:42:02 GMT

You can use the Clear button in the toolbar, though that will clear all selections. You could simply make another selection in the listbox (or table box). Or you could create a button (or text object) and add a Clear Field action on the Actions tab of the button (or text object).