Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
toriekki
Contributor II
Contributor II

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

You can use set analysis for the above scenario.

as below:

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

or

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

View solution in original post

5 Replies
isingh30
Specialist
Specialist

Is this Qlikview or Sense?

felipessj
Contributor III
Contributor III

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

This is Sense.

toriekki
Contributor II
Contributor II
Author

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

You can use set analysis for the above scenario.

as below:

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

or

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