Filtering data on a dimension in expression editor

[Reaperjay]

Hi there.

I`m new to Qlik and am basically learning as i go and would like a little help with a problem.

I have a dimension(Company) which contains four different branches (I, C, N and O). I wanted to only show the results for branches N and O, but i wanted to do them in the expression editor thus removing the need to put a filter itself on the dashboard.

I know if i wanted to focus on just one branch i could use:  =aggr(only({< [Company]={'N'}>} [Company]), [Company])

but what would i use to pull the data relating to either just two or three?

Help please!!

[sunny_talwar · Accepted solution]

May be this for multiple filters

=Aggr(Only({< [Company] = {'N', 'O'}>} [Company]), [Company])

[Reaperjay]

Thanks @sunny_talwar, that seemed to do the trick! I`d been told that the 'only' function was for single entries, but this makes a few more questions a bit more easier to scope now.

---

@sunny_talwar wrote:

May be this for multiple filters

=Aggr(Only({< [Company] = {'N', 'O'}>} [Company]), [Company])

---