Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jessica_webb
Creator III
Creator 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
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

23 Replies
Anil_Babu_Samineni

How is your variable looks?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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

in the variable definition

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
tresesco
MVP
MVP

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
Creator III
Creator III
Author

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

try

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
jessica_webb
Creator III
Creator III
Author

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

vinieme12
Champion III
Champion III

sorry  try as below

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)