Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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])

View solution in original post

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