Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter Field Listed Data

Hi,

I need to filter a list field if a criteria is met example:

list all the accounts where the Account Manager is Mr. White. I need to do that using a formula and not the normal filter Account Manager table.

Attached is an example excel file with the data included.

the requested is to show only the records from Mr. white as a list.

thank you for your help.

1 Solution

Accepted Solutions
sunny_talwar

Not sure where you want to show this? List box? Try this list box expression

=Aggr(Only({1<[Account Manager] = {'Mr. White'}>}[Account Name]), [Account Name])

View solution in original post

5 Replies
sunny_talwar

Not sure where you want to show this? List box? Try this list box expression

=Aggr(Only({1<[Account Manager] = {'Mr. White'}>}[Account Name]), [Account Name])

Anonymous
Not applicable
Author

This worked, perfect

thanks a lot.

can we add another criteria to that? example account manager is Mr. White and Year Created equal 2016?

sunny_talwar

Yes you can:

=Aggr(Only({1<[Account Manager] = {'Mr. White'}, Year = {2016}>}[Account Name]), [Account Name])

Anonymous
Not applicable
Author

Hi and thank you for your help as always,

i want in the list to show more than one project manager actually 4 of them, but the below is not working it is only showing Mr.Black:

Aggr(Only({$<[BI Project Manager] = {'Mr.White'}, [BI Project Manager] = {'Mr.Black'}>}[BI Project Manager]), [BI Project Manager])

how should i amend it to show both Mr.White and Mr.Black?

mgranillo
Specialist
Specialist

Try Aggr(Only({$<[BI Project Manager] = {'Mr.White','Mr.Black'}>}[BI Project Manager]), [BI Project Manager])