Qlik Community

Qlik Sense App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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

Highlighted
Contributor III
Contributor III

This worked, perfect

thanks a lot.

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

Highlighted

Yes you can:

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

Highlighted
Contributor III
Contributor III

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?

Highlighted
Specialist
Specialist

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