Can I have a two sets of filter on one visual?

Q&A
, ,
1

I have a table visual in quicksight where I want two sets of filters applied simutaneously. only include records,

  • if Country is US or CA, then filter on sales number > 1000
  • if Country is MX, then filter on sales number >500
    then the
    is this possible?
Country Sales Rep Amount
US Mark C. 1000
MX Luna K. 800
CA Peter J. 1200
US Mary Q. 1100
CA Marley C. 1700
2

Hi @yuchen1
not directly via filter. Because only OR is available.
But you could create a new calculated field where you use the condition with the AND to create a single value to filter.
e.g.

ifelse( Country is US or CA AND sales number > 1000, "us/ca",
ifelse( Country is MX AND sales number >500, "MX","none")

That way you can filter “us/ca” etc. Or

ifelse(( Country is US or CA AND sales number > 1000) OR ( Country is MX AND sales number >500, 1,0))

In case you want to combine both.

2 Likes
3

thanks Erik! I was able to solve the problem with your advice

1 Like
4

Thanks so much for all your great solutions, @ErikG! :star_struck: :rocket:

5

Perfect. Could you pls solve the topic, too?