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: 
Anonymous
Not applicable

List Box Filtering

Can one restrict the responses to a selection in a list  box to certain sheets of an application rather than to all sheets?  If so, how can this be done.

Thank you.

5 Replies
anbu1984
Master III
Master III

You can use Alternate state to restrict responses of selection in list box. Check this link

Why Comparative Analysis - Technical Brief.pdf

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this document, It will guide you how?

Regards

ASHFAQ

Not applicable
Author

When you select multiple values of a single filter in QlikView, the native behavior is an "OR" operation‒charts will display data points that are associated with any of the selected filter values. This article will show you how you can easily create "AND" (and "NOT") filter boxes in QlikView without any data model modifications!

There are two fields that will be involved in achieving "AND" functionality: (1) the field which we are filtering (let's call this the "filter field"), and (2) the field that we want to be affected by the filter (the "relevant field"). For example, suppose we have a typical sales application that contains customer and product information. We may want to set the filter field to be "Product" such that we can filter in the Product list box with "AND" functionality. We can decide to make the "relevant" field "Customer." If we do, and we select two products, then we are requesting that those Customers that have associations to both of those products be returned. Alternatively, we can set the relevant field to be "Month"‒that would cause those Months that have associations to both products to be returned.

- See more at: http://www.infinityinsight.com/blog/?p=270#sthash.p5VVqdFR.dpuf

morgankejerhag
Partner - Creator III
Partner - Creator III

Alternate States is probably what you are looking for, but depending on the case it can also be feasible to instead ignore certain selections in some calculations. In this case you can use set analysis to ignore the selection:

sum({<FieldToIgnore1=, FieldToIgnore2= >} Amount)

Not applicable
Author

I think set expression is the one you are looking for. And @Morgan has explained very well, It will work with aggregation functions and you can set your selection accordingly.