topic Re: Ignore selections for variable in QlikView

Ignore selections for variable

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Ignore selections for variable

Anil_Babu_Samineni — Thu, 04 May 2017 14:10:33 GMT

How is your variable looks?

Re: Ignore selections for variable

vinieme12 — Thu, 04 May 2017 14:11:58 GMT

in the variable definition

Re: Ignore selections for variable

tresB — Thu, 04 May 2017 14:12:57 GMT

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)

Re: Ignore selections for variable

jessica_webb — Thu, 04 May 2017 14:13:28 GMT

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

Re: Ignore selections for variable

vinieme12 — Thu, 04 May 2017 14:17:23 GMT

try

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

Re: Ignore selections for variable

jessica_webb — Thu, 04 May 2017 14:18:50 GMT

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

Re: Ignore selections for variable

vinieme12 — Thu, 04 May 2017 14:19:27 GMT

sorry try as below

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

Re: Ignore selections for variable

ramasaisaksoft — Thu, 04 May 2017 14:20:32 GMT

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.

Re: Ignore selections for variable

Anil_Babu_Samineni — Thu, 04 May 2017 14:26:03 GMT

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)

Re: Ignore selections for variable

antoniotiman — Thu, 04 May 2017 14:27:59 GMT

Hi Jessica

try this

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

and Expression

=$(vVar({1}))

=$(vVar( ))

Regards,

Antonio

Re: Ignore selections for variable

jessica_webb — Thu, 04 May 2017 14:35:30 GMT

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)

Re: Ignore selections for variable

tresB — Thu, 04 May 2017 14:39:09 GMT

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

Re: Ignore selections for variable

jessica_webb — Thu, 04 May 2017 14:40:05 GMT

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

Re: Ignore selections for variable

tresB — Thu, 04 May 2017 14:41:54 GMT

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.

Re: Ignore selections for variable

jessica_webb — Thu, 04 May 2017 14:42:43 GMT

Absolutely perfect solution! Exactly what I needed.

Thank you so much

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

Re: Ignore selections for variable

vinieme12 — Thu, 04 May 2017 14:48:06 GMT

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?

Re: Ignore selections for variable

vinieme12 — Thu, 04 May 2017 14:52:23 GMT

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

Re: Ignore selections for variable

jessica_webb — Thu, 04 May 2017 14:55:51 GMT

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

Re: Ignore selections for variable

antoniotiman — Thu, 04 May 2017 15:07:47 GMT

Hi Jessica,

why not use $1 parameter in vVar ?

See Attachment.

Regards,

Antonio