topic List Box Filtering in QlikView

List Box Filtering

Anonymous — Sat, 15 Nov 2014 05:48:50 GMT

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.

Re: List Box Filtering

anbu1984 — Sat, 15 Nov 2014 05:54:33 GMT

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

Why Comparative Analysis - Technical Brief.pdf

Re: List Box Filtering

ashfaq_haseeb — Sun, 16 Nov 2014 05:47:36 GMT

Hi,

Check this document, It will guide you how?

Regards

ASHFAQ

Re: List Box Filtering

Sun, 16 Nov 2014 15:13:10 GMT

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

Re: List Box Filtering

morgankejerhag — Sun, 16 Nov 2014 15:35:10 GMT

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)

Re: List Box Filtering

Sun, 16 Nov 2014 16:39:46 GMT

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.