topic Re: List Box in QlikView

List Box

Mon, 14 Dec 2015 15:06:49 GMT

Good day,

I have loaded a table of
employees with 2 fields: EmployeeID, and EmployeeName.

I have also loaded a transaction
table that also has EmployeeID (and can have multiple transactions for one
Employee Id) along with other data fields.

When I create a list box using
the Employee Name, I see all the Employee names and not just the ones that have
transaction records.

How can I have the List box only
show the Employee Names with transactions?

Thank you very much,

Mitch

Re: List Box

Clever_Anjos — Mon, 14 Dec 2015 16:00:03 GMT

Something like

Aggr(Only({<TransactionFieldName={"*"}>}EmployeeName),EmployeeID)

Re: List Box

swuehl — Mon, 14 Dec 2015 16:03:17 GMT

You can use an expression in the list box instead of just a field name (select <expression> from field drop down list on general tab of list box properties):

=Aggr( If(Count(TransactionID)>0,EmployeeName), EmployeeName)

=Aggr( Only({<EmployeeName = {"=count(TransactionID)>0"}>} EmployeeName), EmployeeName)

Re: List Box

Tue, 15 Dec 2015 19:35:57 GMT

I tried this and unfortunately it did not work.
I still see all the Employee names and not just the ones that have
transaction records.

Re: List Box

rwunderlich — Tue, 15 Dec 2015 20:19:53 GMT

In the example given, the posters guessed at the name of a field in your transaction table. Can you post the expressoin you tried and confirm that it refers to a field that exists in your transaction table?

-Rob

Re: List Box

swuehl — Tue, 15 Dec 2015 20:19:58 GMT

If you create a list box for field EmployeeName and a list box for a field from Transaction table, which should have a value in all records, like Transaction amount or TransactionID, and if you then right click on the transaction table field list box and 'Select all', are there any values in EmployeeName list box greyed out?