Quicksight: filters do not work

Q&A
, , ,
1

Hi All,
In my analysis, I am already filtering costs by day, month, year. I successfully just added another filter to get costs by product names, let’s say A-B-C-D-E-F-G products only out of [A-Z] products list.
Moreover, I also want the users - which do not develop this analysis and do not have the rights to access [H-Z products] costs - to autonomously further filter available product names and e.g. get just A-C-F out of [A-G]. To do that, I added a multiselect dropdown control and selected “SHOW RELEVANT VALUES ONLY” to match only the selected filter values A-B-C-D-E-F-G. This seemed to work at first, but then I faced this issue, here are the steps: 1. My control just shows A-B-C-D-E-F-G (which is great); 2. I remove A-B-C and everything is ok; 3 I add B-C back and everything is still great; but 4. when I add A - the last value that is available in my control - I get costs for all products [A-Z] and the control dropdown is set = All even if I chose “Hide Select all option from the control values”. What am I missing? I cannot give the users the rights to see the costs for all the products unfortunately, they can just access that subset only.
Thanks!!

2

Hi @GaBon ,

Welcome to the Quick Sight Community!!

You can achieve this by implementing RLS based on user name mapping. Considering you want to restrict data at user level, this would be restricting viewing all records. You can read here for detailed steps.

As to justify why this behaviour, the filter definition All automatically selects all field values available rather than selected set of values causing this confusion.
Thanks,
Prantika

3

Thanks @prantika_sinha, this really helps me :slight_smile:

I managed to add a csv including two columns UserName and tag_X to define rules and it seems to work. What if I need to define rules for more than one tag? e.g. if i want some users to see all tag_X values, but just tag_Y = Z? I mean something like this

UserName;tag_X;tag_Y
gabon@…;all possible value;Z
bonga@;A,B,C;all possible values

Thanks

4

Did you try keeping the value as Null when providing access to all records?

5

Resolved by not specifying any value at all for those tags. Thanks for your help!