How to use two identifiers in one set analysis

[suryajeganathan]

Hi

I am trying to use two identifiers in one set analysis.

In the below case i dint want my formula to consider Type Field that i mentioned like 1<TYPE= & remaining fields has to be considered

ex country_name,ww_segment etc.

How to achieve this?

(SUM({1<TYPE=,fiscal_quarter=,week_start ={">=$(=date(QuarterStart(Max(week_start)))) <=$(=date(AddYears(Max(week_start))))"}

,country_name,ww_segment=,bpc_segment_description=,geography

>}accessories_revenue_yoy)

[YoussefBelloum]

Hi,

you already removed Type field by using this: TYPE=

to consider country_name and vw_segment, just remove them from the set analysis.

or I'm missing something ?

[suryajeganathan]

If i am removing those fields (country_name ,ww_segment) from the set analysis . The data is get filtered out if i select the country_name & ww_segment filter

That is my issue...

[suryajeganathan]

If i am removing those fields (country_name ,ww_segment) from the set analysis . The data is not getting filtered out if i select the country_name & ww_segment filter

That is my issue...

[sunny_talwar]

What exactly do you mean when you say "remaining fields has to be considered"? It seemed that you wanted to allow selection in those fields... but thne you said "The data is get filtered out if i select the country_name & ww_segment filter"? I would have thought that being considered means that you allow for selections

[suryajeganathan]

Hi Sunny

Sorry for the confusion.

TYPE - I don't want to allow the selection that is already achieved in my above expression

But wen the user selects country_name & ww_segment the expression should allow the selection and the data in the dashboard shld get filtered out accordingly

If i remove those field(country_name & ww_segment) from the set analysis its not happening. So how to achieve?

[suryajeganathan]

Hi Guys

i changed my expression like below

SUM({1<TYPE,fiscal_quarter=$::fiscal_quarter,geography=$::geography,country_name=$::country_name,ww_segment=$::ww_segment,bpc_segment_description=$::bpc_segment_description>}

ship_accessories_revenue)

The data is getting filtered out ... But the Measure Values are coming wrong...I dont know why

Can any help me ?

[sunny_talwar]

You need to remove 1 from your expression also

[suryajeganathan]

below mentioned expression is working fyn...Tanq all for ur help

SUM({<TYPE>}

ship_accessories_revenue)