How to ignore filter in a table?

[Anonymous]

I have two tables in my sheet. First table is as follows:

CustID      Total Product count

Totals        17

1                2

2                4

3                3

4                2

5                1

6                5

And the second table shows data only, if I have one CustID selected(done by add-ons GetSelectedCount). This table shows products from selected customer:

CustID      Product        Product count

3               Hammer       2

3               Saw              1

I also have a filter to filter different products to count total number of different products in the first table. How can I ignore this filter in the second table so that it always shows all the products of chosen customer?

[isingh30]

Is this Qlikview or Sense?

[felipessj]

use analysis set to avoid filtering through the customer field "sum ({<customer =>} Product count" in the expression of the second table

usa set de analisis para evitar filtrar por el campo customer "sum({<customer=>} Product count" en la expresión de la segunda tabla

[Anonymous]

This is Sense.

[Anonymous]

I know how to use set analysis in fields that do calculations (sum, count, etc), but how I can ignore filters in dimensions like customer ID or Customer name? And to be clear, customer field is exactly the field I want to use as a filter in the second table and ignore all other filters.

[rangam_s · Accepted solution]

You can use set analysis for the above scenario.

as below:

Sum({<Product=>}[Product count])

or

Count({<Product=>}[Product count])