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 getting : A table of multiple values was supplied where a single value was expected.
 
Can anyone help?
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 

     

3 Replies

  • 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"} )