Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Listbox with selected and excluded values

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

5 Replies
YoussefBelloum
Esteemed Contributor

Re: Listbox with selected and excluded values

Hi,

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

Partner
Partner

Re: Listbox with selected and excluded values

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

YoussefBelloum
Esteemed Contributor

Re: Listbox with selected and excluded values

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)

Digvijay_Singh
Honored Contributor III

Re: Listbox with selected and excluded values

May be this -

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

Partner
Partner

Re: Listbox with selected and excluded values

Hi Digvijay,

Unfortunately that doesn't show the extra idCustomers