Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exclude multiple values from Column Filter

I'm currently trying to filter a column "Value" to ensure the following values dont appear:   Sheep Enterprise Flock 1 Sheep Enterprise Flock 2 Lambs From Previous Year to Sell   But keep gett...
Need Help
  • AlB's avatar
    AlB
    6 years ago

    Hi Anonymous 

    Try NOT IN instead of the inequality for your condition:

    NOT Looker_tables lkr_Form_Checkbox_Answer'[Value] IN {"Sheep Enterprise Flock 1","Sheep Enterprise Flock 2","Lambs From Previous Year to Sell"}

    Please mark the question solved when done and consider giving kudos if posts are helpful.

     

     Cheers 

     

AlB's avatar
AlB
Community Champion
6 years ago

Hi Anonymous 

Try NOT IN instead of the inequality for your condition:

NOT Looker_tables lkr_Form_Checkbox_Answer'[Value] IN {"Sheep Enterprise Flock 1","Sheep Enterprise Flock 2","Lambs From Previous Year to Sell"}

Please mark the question solved when done and consider giving kudos if posts are helpful.

 

 Cheers 

 

  • EllenG's avatar
    EllenG
    Frequent Visitor
    6 years ago

    Worked for me too! Thank you AlB Super User III !!

  • romgut's avatar
    romgut
    Advocate III
    5 years ago

    It's also working as part of the calculate syntax , e.g.

     
    Measure =
    CALCULATE ( COUNTROWS(table) , table[field]="Lost" , not table[field] in {"PTG 1A", "PTG 1B"} )