Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone. I am having some issues doing a task. I have a filter pane with a dimension called , let's say, dimensions A. I then have a straight table with many dimensions, one of them B. This 2 dimensions are not conected in any way and they should stay that way. What i want is, if the user selects a value of dimension A, in the straight table, I should only see for dimension B the value selected.
Let me put an example:
Dimension A has these values: 1111,2222,3333,4444,5555,6666,7777,88888,9999,0000
Dimension B has these values: 1111,2222,3333,4444,5555,6666,7777,121212,323232,0000
If the user selects in dimension A a value, value 2222, and that value exists in dimension B then...
That same value, as it exists on dimension B, should get selected as well and filter the table accordingly.
I tried something like this->
=Aggr(Only({<B, A= P(B)}>} B), B) but it is not working
Please keep in mind that i dont have access to the script
If I have undestood, your user is going to make his selections on A dimension. If so, your calculated dimension should look like this
=aggr(Only({<A,B=P(A)>} B),B)
Hope it helps
Regards
here is an example :
Suppose I have this Input:
TableA:
load * inline [
Dimension A
1111
2222
3333
4444
5555
6666
7777
88888
9999
0000
];
TableB:
load * inline [
Dimension B,Value
1111,1
2222,2
3333,3
4444,4
5555,5
6666,6
7777,7
121212,8
323232,9
0000,10
];
no relation between Dimension A and Dimension B
I create straight table with Dimension B and Value
Dimension :
=Aggr(Only({<[Dimension B]= {$(=chr(39)&GetFieldSelections([Dimension A],chr(39)&','&chr(39))&chr(39))}>} [Dimension B]), [Dimension B])
output:
if I select one value In Dimension A:
or many
@forte first of all thank you for your answer!!!!
this is only showing the values that the 2 dimensions share....so it doesn't work
i tried to put it in an if, so
if(getSelectedCount(A)>0,your-expression, B)
But this makes it worse, it is just not working 😞
Hi @Taoufiq_Zarra , this isn't working for me, it is showing nothing! could you pass your file so I can see exactly what you did??? Because the idea is there! thank you
attached qvf file
Sorry @EugeniaCastillaFragoso , I think I misundestood your scenario.
Show you need something like this
So your calc dimension should look like this
=aggr(Only({<A,B=P(A)>} B),B)
&
aggr(Only({<A,B=B-P({1} A)>} B),B)
Attached example I used
Hope it helps
Regards