Ignore selections for variable

[jessica_webb]

Hi,

I have a chart with one dimension and one expression - the expression being a variable: $(vVar)

How do I make my chart ignore all selections? I understand that I need to use set analysis {1}, but where do I put it in my expression?

Many thanks,
Jess

[Anil_Babu_Samineni]

How is your variable looks?

[vinieme12]

in the variable definition

[tresesco]

That depends on how your variable is defined. If the definition has aggregation function(s), you have to include {1} in them. Like:

vVar= Sum({1} Sales)

[jessica_webb]

SUM(Points)/SUM(Size)

But I don't want to write anything else into the variable expression, as in other places I do expect it to respond to selections.

Thanks,

Jess

[vinieme12]

try

SUM( {1}  AGGR(  $(vVar), DimensioninChart) )

[jessica_webb]

Afraid that doesn't work - 'No data to display'

[vinieme12]

sorry  try as below

SUM( {1}  AGGR(  $(vVar), DimensioninChart) )

[ramasaisaksoft]

approximately you can use like this Sum(1{<$(vSegment)={'All'}>} Sales)

else provide your sample data and expected output so that our folks will help to u.

[Anil_Babu_Samineni]

I don't think whether below conditions works for you. Why not in Variable overview. Is there any restriction?

like below

SUM({1} Points)/SUM({1} Size)