Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jessica_webb
Contributor III

Ignore selections for variable

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

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Ignore selections for variable

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

View solution in original post

23 Replies

Re: Ignore selections for variable

How is your variable looks?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Esteemed Contributor II

Re: Ignore selections for variable

in the variable definition

MVP
MVP

Re: Ignore selections for variable

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
Contributor III

Re: Ignore selections for variable

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
Esteemed Contributor II

Re: Ignore selections for variable

try

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

jessica_webb
Contributor III

Re: Ignore selections for variable

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

vinieme12
Esteemed Contributor II

Re: Ignore selections for variable

sorry  try as below

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

ramasaisaksoft
Valued Contributor III

Re: Ignore selections for variable

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

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)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)