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

[antoniotiman]

Hi Jessica

try this

vVar = Sum($1 Points)/Sum($1 Size)

and Expression

=$(vVar({1}))  

or

=$(vVar( ))

Regards,

Antonio

[jessica_webb]

Thank you all for the helpful suggestions. I've tried all of them, but unfortunately none of them have worked so far.

I can't make changes to the expression within the variable, as the variable is used in several places and most of the time I expect the variable to respond to all field selections. Therefore, changing the variable expression to Sum($1 Points)/Sum($1 Size) will not work.

What I need is a way to get just this individual chart to ignore all field selections. But I don't know how because I don't have any set analysis within the expression. Only $(vVar)

[tresesco]

One easy way could be : Right click on the chart-> Detach

[jessica_webb]

Is that permanent? I always thought it was just temporary...

[tresesco]

Until, you Attach it back.

Edit: You are CORRECT . It is temporary, I stand corrected.     Thanks vinieme12‌ for the correction.

I suggest another solution using Alternate State; see if that fits your requirement. Also, please unmark the correct status.

[jessica_webb]

Absolutely perfect solution! Exactly what I needed.

Thank you so much

Or not, looks like it reattaches itself! But thank you anyway!

[vinieme12]

Nope an object stays detached only until the session lasts which means the next time you open the QVW it will be attached again

did you try with AGGR() the way i provided?

[vinieme12 · Accepted solution]

or you may simply create another variable for this particular chart!

[jessica_webb]

Ah, I thought the detach thing was temporary

I did try the AGGR, but not only did it make my values incorrect, it still took on any selections I made.

Think you're right, will have to create yet another variable!!!

Thank you

[antoniotiman]

Hi Jessica,

why not use $1 parameter in vVar ?

See Attachment.

Regards,

Antonio