Showing excluded values in a Qlik Sense table

[skiruthigadevi]

Hello Friends,

Appreciate your time. I am looking for a solution to show the excluded values(in the grey color instead of disappearing) after making a selection in my Qlik Sense table.

for example,

let say I have the below table

customer,units

1,10

2,20

3,30

4,40

5,50

In a QS table, when I click  the first row, the rest are all getting removed, Is there any way to show it in a gray color instead?

I have attached a demo app for your reference

below is my expression

units: aggr(sum(qty),customer) 

Thank you,

Kiruthiga

[TimvB]

At first, we need to make sure that the rows that are excluded from the selection do not hide. This can be done by including “{1}” in the measure expressions, i.e., sum({1} Field). This makes sure that all the filter selections are ignored for the expressions, thus, the rows will not hide. 

Second, we need to color the rows that are excluded from the selection. This can be done by using the “background color” for every dimension and measure of the table with the following color expression: 

If(Not Match(Field, GetFieldSelections(Field)), LightGray(), Null())

Hope it helps!