topic Showing excluded values in a Qlik Sense table in App Development

Showing excluded values in a Qlik Sense table

skiruthigadevi — Fri, 21 Feb 2020 16:09:26 GMT

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

Re: Showing excluded values in a Qlik Sense table

TimvB — Sat, 22 Feb 2020 20:13:37 GMT

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!