Intersection

[mukesh19]

Hi all,

I have a problem that is I have two filter panes with the same dimensions, If I select a value in the first filter pane and another value in the other filter pane, I want the result to be as the intersection of both the values selected rather than the union.

regards,

sai.

[Chanty4u]

try this

Aggr(Count( {$<Field= {'Value1', 'Value2'}>} Dim1), Dim2)

or

=count (distinct  {<code = P ({<exam={"1"}>} code ) >*<code = P ({<exam={"2"}>} code ) > } code )

[mukesh19]

can u please elaborate the syntax what u have written thats not working

[agigliotti]

maybe this:

Suppose you have two fields (DimField1, DimField2) in your data model related to the same database field (DimField).

ex.

{< DimField = P(DimField1) * P(DimField2) >}

[mukesh19]

both the fields are same in two filter panes after selections in both the filter panes I want intersection rather than union.

[agigliotti]

you can't achieve it using only one field, you need to create two extra fields in your script as I wrote before.

[mukesh19]

hi chanty,

What you wrote is fine but, Instead of count I need the code values . How can I achieve it.

Thanks in Advance,

Sai

[agigliotti]

maybe this:

Concat( {< DimField = P(DimField1) * P(DimField2) >} code, ';' )

[mukesh19]

Its not Working