Qlik Community

Qlik Sense App Development

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

asaadsaleh
New 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.

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Filter Field Listed Data

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

5 Replies
MVP
MVP

Re: Filter Field Listed Data

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
New Contributor III

Re: Filter Field Listed Data

This worked, perfect

thanks a lot.

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

MVP
MVP

Re: Filter Field Listed Data

Yes you can:

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

asaadsaleh
New Contributor III

Re: Filter Field Listed Data

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?

kidbank3
Contributor III

Re: Filter Field Listed Data

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

Community Browser