Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Reaperjay
Contributor
Contributor

Filtering data on a dimension in expression editor

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!!

1 Solution

Accepted Solutions
sunny_talwar

May be this for multiple filters

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

View solution in original post

2 Replies
sunny_talwar

May be this for multiple filters

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

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