Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
asaadsaleh
Contributor III
Contributor III

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])

asaadsaleh
Contributor III
Contributor III
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])

asaadsaleh
Contributor III
Contributor III
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])