Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use Alternate state to restrict responses of selection in list box. Check this link
Hi,
Check this document, It will guide you how?
Regards
ASHFAQ
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
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)
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.