Recalculating a value based on only certain filters

[amr_qlik]

Hi,

If I'm trying to calculate a value, say Sales, to be displayed in a top 10 bar chart, and  I have 3 filters: product category, fiscal year, and product number, is there a way so that only one or two of those filters can affect the calculation via the filter, which in turn changes my top 10 visualization.  Right now everything is held static so the top 10 never changes, but I want the top 10 to readjust when the product category or fiscal year filters are used.

Is this possible?

[Chanty4u]

Hi,

if you want to ignore the Product Number from the selection you can try below.

    sum ({<[Product Number]>} sales)