Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BarryPollock
Contributor III
Contributor III

Can I define which charts a filter affects?

Lets say I want to have a Country filter that I want to affect two charts on a sheet but not the third chart.  Can that somehow be defined in the application?

Lets consider the following uploaded tables:

Sport_Table:

Country   Sport
USA            Basketball
USA            Hockey
Canada     Basketball
Canada     Hockey



Athlete_Table:

Country   Athlete
USA            Bill
USA            Julie
USA            Miguel
Canada     George
Canada     Jill




My understanding is that if I load these two tables and create an "association" (connecting the two circles) between the two tables, there will exist one Country filed that will control all charts that uses an of the fields in the two tables.

If I don't create an association, then the second table will have the Country field renamed to Sheet1-1.Country.  In this case, a filter with the Country dimension will only filter tables that include either the Country field or the Sport field.  Likewise a filter with the Sheet1-1.Country field will only filter tables that include either the Sheet1-1.Country field or the Athlete field.  


What if I wanted to do both?

What if I want the country field to affect both Sports and Athletes in two of the charts, but for visualization purposes I want a third chart that isn't affected by filters?


The only way I can think to do it would be to load the tables twice.  One pair would have an association made, while the second pair would not.  Or, perhaps I can create a dummy variable that links the two together?  I'm not sure how that would work.

Thanks!






1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

In the Set Analysis statement, {<Field=>} says that Field will ignore any filters on Field.  You could have one or more fields in the Set Analysis statement, {<Field1=,Field2=,Field3=>} and the expression  would ignore filters on those fields.

View solution in original post

3 Replies
jwjackso
Specialist III
Specialist III

You could use an Alternate State in the chart that should not be affected by filters.  Or if you are using Set Analysis in the third chart, you can have the Country ignore filters.

Count({<Country=>} Sport)

BarryPollock
Contributor III
Contributor III
Author

@jwjackso 

Thanks!  The alternate state method looks promising.

As for the second method, it works, but I don't understand the syntax or how it applies to the chart.  Can you explain that?

What if I just wanted to have a Country column and a Sport column.  Since I don't have a Count of Sports column, I wouldn't be able to apply the {<Country=>} piece that seems to be overriding the country filter.

Is there a way to write that into either the Country or Sport dimension?




 

Edit:  I did figure out how to disconnect multiple multiple filters by using commas:

Count({<Country, Sport, Athlete=>} Sport)

 

jwjackso
Specialist III
Specialist III

In the Set Analysis statement, {<Field=>} says that Field will ignore any filters on Field.  You could have one or more fields in the Set Analysis statement, {<Field1=,Field2=,Field3=>} and the expression  would ignore filters on those fields.