Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filtering in 'Expression Editior'

Hello,

I am new to Qlik Sense and I am attempting to add a filter to dimension within my table.  I edit the 'Expression Editor' for my dimension called [State] and try to enter code to equal only one state.  I know I can add a filter pane to the sheet but would like to exclude pulling in all of the rows when I only need a specific state from my app into this sheet.  The expression I am trying to use and keeps failing is below:

=[State of Jurisdiction]={FL}

Am I doing this correctly?  Any help will be greatly appreciated.

DBrown

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Filtering in 'Expression Editior'

aggr(only({<[State of Jurisdiction]={'FL'}>} [State of Jurisdiction]), [State of Jurisdiction])

6 Replies
mov
Esteemed Contributor III

Re: Filtering in 'Expression Editior'

aggr(only({<[State of Jurisdiction]={'FL'}>} [State of Jurisdiction]), [State of Jurisdiction])

Not applicable

Re: Filtering in 'Expression Editior'

That worked perfectly!

Not applicable

Re: Filtering in 'Expression Editior'

Michael that worked perfectly.

Thank you so much!!!!

Not applicable

Re: Filtering in 'Expression Editior'

Michael,

Is there a beginners guide on expression writing that I can review?  I've searched all through the site but found nothing close to what you sent which worked perfectly.  Any help is appreciated.

mjtaft2017
Contributor

Re: Filtering in 'Expression Editior'

Please mark mov's answer as correct so this does not appear unanswered and he will be credited for the correct response.

thank you.

mov
Esteemed Contributor III

Re: Filtering in 'Expression Editior'

The is a quite comprehensive bookQlikView 11 for Developers - QlikView Book

It for QlikView,but the expression and script syntax are the same in Sense.
Anyway, the information in "help" is good enough for the beginners, and it is free.

Community Browser