Disregard Current Selection Together with other Parameter in Set Analysis

[#1]

Dear all,

I have a data source similar to the following one

File_ID	User_ID	Admin	Owner
0001	U001	A	V
0002	U001	A
0003	U003	A	V
0004	U003	A
0005	U002		V
0006	U001	A
0007	U004	A
0008	U002		V

I want to create a chart like the following.

The dimension i used is

=aggr(if(rank(aggr(count(Admin),User_ID))<=vTopN,User_ID)),User_ID)), where the variable vTopN is set to be 3

and the expression is

=count({Admin={'A'}} Admin)

=count({Owner={'V'}} Owner)

User_ID	Admin Count	Owner Count
U0001	3	1
U0003	2	1
U0004	1	0

The table created is as what I expected.

What I am not able to achieve now is that when I double click on the User_ID, the resulted table will show the only Used_ID that I clicked.

I know that I can added a set analysis expression like =count({$<Admin={'A'},User_ID=>} Admin) to disregard the current selection,

but it is no working this time. I wonder if it is related to the other set analysis expression that I am using.

Could anyone help? Thanks a lot.

[Gysbert_Wassenaar]

See attached qvw

[#3]

Thanks for your reply. Sorry that I may have make it clear in my question. Actually I would like to disregard the current selection so that when I click on the User_ID U001, the table will remain like table 1 instead of table 2. Wonder if there is any way to achieve this based on my existing dimension and expression.

[Gysbert_Wassenaar]

In that case, try using Dimension Limits. See attached updated qvw (don't forget to delete my earlier document first).

[#5]

Thanks a lot for your reply. It works well.

Just wonder if there is alternative apart from the dimension limit.

The reason I ask this is that I want to replace Admin with a variable, say vField. So that use that chose either Admin

or Owner on the fly, and there is also a variable called vTop, which allow users to choose the Top N Owner/Admin.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#7]

Million thanks! it is exactly what I need