12 Replies Latest reply: Nov 22, 2017 10:55 AM by Sunny Talwar

# Set Analysis - disregard current selection ?

Hi all,

Here is a Dimension -

MKTGvsBU  has values :  'MKTG' , 'BU'

Here is a bar chart showing sum of sales for  'MKTG' , 'BU'

Expressions in bar chart

Bar 1. sum ( { \$ <MKTGvsBU = {'MKTG'}>} sales)

Bar 2. sum ( { \$ < MKTGvsBU = {'BU'}>}sales)

When I make selections in MKTGvsBU filter the bars do not change.

How do I disregard current selection so that the bars will respond to filter selections  ?

• ###### Re: Set Analysis - disregard current selection ?

With your expressions , you've fixated the bars and forced them not to change if you filter by your MKTGvsBU   dimension.

With that said, your question is not clear; what exactly do u want to do?

• ###### Re: Set Analysis - disregard current selection ?

Hi, just create a bar chart with dimension MKTGvsBU  and measure Sum(Sales)

Maybe there is something else you haven't said yet,

Cheers,

Luis

• ###### Re: Set Analysis - disregard current selection ?

HI,

Refer to the attached sample,

method 1 :

set identifier of 1, which ignores all selections and return full set value.

Fact:
Date, MKTGvsBU, Sales
30/10/2017, MKT, 2500
11/10/2017, BU, 3780
9/11/2017, MKT, 1900
17/10/2017, BU, 2400
];

You dimension

MKTGvsBU

Bar expression for BU:

Sum({1<MKTGvsBU={'BU'}>}Sales)

Bar expression for MKT:

Sum({1<MKTGvsBU={'MKT'}>}Sales)

Method 2:

by using alternate state

Sum({\$< MKTGvsBU= \$::MKTGvsBU,MKTGvsBU={'BU'}>}Sales)

Sum({\$< MKTGvsBU= \$::MKTGvsBU,MKTGvsBU={'MKT'}>}Sales)

• ###### Re: Set Analysis - disregard current selection ?

Try this

Sum({\$<MKTGvsBU *= {'MKTG'}>} sales)

Sum({\$<MKTGvsBU *= {'BU'}>} sales)

Implicit Set Operators

• ###### Re: Set Analysis - disregard current selection ?

Sorry guys none of the suggestions work.  Sunny it says  ! Error in expression . Alternate States is not working either

The bars must show  sum ( Sales) for the 2 separate units as stated int he expression. ( MKTG, BU)  But also must respond to filter selection  (MKTG , BU)    . Bars are not moving due to set analysis expression.

• ###### Re: Set Analysis - disregard current selection ?

Alternate State? Where did the alternate state come from?

• ###### Re: Set Analysis - disregard current selection ?

For the expressions I provided, what error message are you getting?

• ###### Re: Set Analysis - disregard current selection ?

Ok it works now Sunny. It was the spacing ! I had space between  MKTGvsBU * . It's MKTGvsBU*    Thank you so much !!!

• ###### Re: Set Analysis - disregard current selection ?

That is strange, was it the space between MKTGvsBU and * or space between * and =? I would think the later?

• ###### Re: Set Analysis - disregard current selection ?

All of it. I had it as MKTGvsBU  *  =  .  It works when no space  MKTGvsBU*=

• ###### Re: Set Analysis - disregard current selection ?

You can do this

MKTGvsBU*=

but, this would also work

MKTGvsBU *=