topic Controlling where default filtering is applied in QlikView

Controlling where default filtering is applied

Thu, 01 Nov 2012 18:06:29 GMT

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

Re: Controlling where default filtering is applied

Thu, 01 Nov 2012 18:11:34 GMT

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.

Re: Controlling where default filtering is applied

MayilVahanan — Thu, 01 Nov 2012 18:13:07 GMT

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

Re: Controlling where default filtering is applied

Anonymous — Thu, 01 Nov 2012 18:54:44 GMT

use alternative states and follow this video

http://youtu.be/YVy0DE51z5M