Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

toriekki
New Contributor

How to ignore filter in a table?

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?

1 Solution

Accepted Solutions
rangam_s
Contributor II

Re: How to ignore filter in a table?

You can use set analysis for the above scenario.

as below:

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

or

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

5 Replies
isingh30
Contributor III

Re: How to ignore filter in a table?

Is this Qlikview or Sense?

felipessj
New Contributor III

Re: How to ignore filter in a table?

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

toriekki
New Contributor

Re: How to ignore filter in a table?

This is Sense.

toriekki
New Contributor

Re: How to ignore filter in a table?

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
Contributor II

Re: How to ignore filter in a table?

You can use set analysis for the above scenario.

as below:

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

or

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

Community Browser