Filtering in 'Expression Editior'

[#1]

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

[Anonymous · Accepted solution]

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

[#3]

That worked perfectly!

[#4]

Michael that worked perfectly.

Thank you so much!!!!

[#5]

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]

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

thank you.

[Anonymous]

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.

[Higor]

I'm new to qlik and that helped me a lot, thanks!

i only wanted some of my results to shown in a pivot table.

my dimension expression ended like this:

=aggr(only({<key_codfil={'1','3','4','6','7','8','10','11','12','13','18','19','20','21','22','24','25','26','28','29','30','31','999'}>}key_codfil),key_codfil)