Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Controlling where default filtering is applied

I'm new here, sorry if this a real easy one!

How do I control where/how the default filtering is applied?

For instance - I have a list box and when I click an item it filters everything on my dashboard - how do I make this filter one chart, but leave another one alone?

Also, when I click a bar in a chart, I don't want it to filter itself - this always leaves me with one big bar - clearly not desirable, so how do I prevent this?

Cheers

Tom

3 Replies
Not applicable
Author

Look into using alternate states.  This will allow you to have a filter apply to some things and not others.  For the bar chart, you can select 'Read Only' on the General tab if you don't want users to be able to click to select.

MayilVahanan

Hi

Are you asking like this

For one chart, filters want to apply. but not for another one..

if so,

try like this,

=in expression use something like this

sum({1}sales) // it exclude all selections

sum({<Year=, Month=>}sales) // it exclude year n month field alone

2.Also, when I click a bar in a chart, I don't want it to filter itself - this always leaves me with one big bar - clearly not desirable, so how do I prevent this?

So for you, don't want to selection in field? am correct?

if so, use like this

=sum({1} sales)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

use alternative states and follow this video

http://youtu.be/YVy0DE51z5M