topic Listbox with selected and excluded values in QlikView

Listbox with selected and excluded values

j_nlucas — Mon, 23 Apr 2018 14:39:06 GMT

Hello,

I've got the following scenario:

- 1 table for area managers linked to fact table through IdManager

- 1 table for customers linked to fact table through IdClient

- 1 field Idmanager2 in the Customers table

When a area manager is selected, this will give me a list of customers that come from the relationship with the manager. These are the possible customers.

But from the list of excluded customers, there are some with the same IdManager in the field IdManager2, that I also want to show.

So, what I am trying to put together in a list box (or as dimension in a table)

- All the possible customers

- All the excluded customers with the Idmanager selected in their IdManager2 field

My approach is this:

CONCAT({<CLIENTE=P(CLIENTE)>}IdCustomer,',') --> List of selected customers (linked to the IdManager). This half works.

CONCAT({<CLI_FIGURARESP=E(IdArea_manager)>}CLIENTE,',') --> List of customers with the IdManager on the table. It's not working

Datamodel attached.

Table FIGURA is for Area managers. Fields FIGURA and IdManager are the same

Table Cliente is for customers. CLI_FIGURARESP is the IdManager

Any idea?

Thank you

Joaquin

Re: Listbox with selected and excluded values

YoussefBelloum — Mon, 23 Apr 2018 14:59:32 GMT

Hi,

would you be able to attach sample data from each table and describe the exptected output ?

Re: Listbox with selected and excluded values

j_nlucas — Mon, 23 Apr 2018 15:15:59 GMT

Hi Youseff thanks for your quick reply. I just updated the post and uploaded the data model. Maybe that will help.

Re: Listbox with selected and excluded values

YoussefBelloum — Mon, 23 Apr 2018 15:55:24 GMT

if you're using listboxes, concat will not work, you will need to use only with aggr(), like this:

let's look at the first one :

=Aggr(only({<CLIENTE=P(CLIENTE)>}IdCustomer),IdCustomer)

Re: Listbox with selected and excluded values

Digvijay_Singh — Mon, 23 Apr 2018 17:35:20 GMT

May be this -

Aggr(only({<CLIENTE=P(CLIENTE)>+<CLI_FIGURARESP=E(IdArea_manager)>}IdCustomer),IdCustomer)

Re: Listbox with selected and excluded values

j_nlucas — Tue, 24 Apr 2018 07:17:36 GMT

Hi Digvijay,

Unfortunately that doesn't show the extra idCustomers