-
Re: Intersection
Chanty 4u Sep 18, 2017 6:05 AM (in response to Mukesh Baba Kodeboina)try this
Aggr(Count( {$<Field= {'Value1', 'Value2'}>} Dim1), Dim2)
or
=count (distinct {<code = P ({<exam={"1"}>} code ) >*<code = P ({<exam={"2"}>} code ) > } code )
-
Re: Intersection
Mukesh Baba Kodeboina Sep 18, 2017 6:19 AM (in response to Chanty 4u)can u please elaborate the syntax what u have written thats not working
-
Re: Intersection
Mukesh Baba Kodeboina Sep 19, 2017 7:09 AM (in response to Chanty 4u)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
-
Re: Intersection
Andrea Gigliotti Sep 19, 2017 7:13 AM (in response to Mukesh Baba Kodeboina)maybe this:
Concat( {< DimField = P(DimField1) * P(DimField2) >} code, ';' )
-
Re: Intersection
Mukesh Baba Kodeboina Sep 19, 2017 7:16 AM (in response to Andrea Gigliotti )Its not Working
-
-
-
-
Re: Intersection
Andrea Gigliotti Sep 18, 2017 6:30 AM (in response to Mukesh Baba Kodeboina)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) >}
-
Re: Intersection
Mukesh Baba Kodeboina Sep 18, 2017 6:37 AM (in response to Andrea Gigliotti )both the fields are same in two filter panes after selections in both the filter panes I want intersection rather than union.
-
Re: Intersection
Andrea Gigliotti Sep 18, 2017 6:46 AM (in response to Mukesh Baba Kodeboina)you can't achieve it using only one field, you need to create two extra fields in your script as I wrote before.
-
-