Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

smurfstar80
New Contributor II

Can I filter a table by background colour?

I have a table of data where I have created an expression for the background colour of the cell to turn Red if a certain word appears in the cell

However.  I would like to know if there is a way I can filter to see just the highlighted cells in the column.

Also, is there a way I can stop losing my place in the table when switching between sheets?  If I scroll down this column, view a different sheet then come back to it, it automatically takes me back to the top of the table.

Any help would be appreciated.

1 Solution

Accepted Solutions
smurfstar80
New Contributor II

Re: Can I filter a table by background colour?

To answer my own question and for anybody else's reference, the only solution I have found as a workaround is to create a filter using the same expression I used for the background colour, except using 'Abbreviation Needed' instead of Red().

1 Reply
smurfstar80
New Contributor II

Re: Can I filter a table by background colour?

To answer my own question and for anybody else's reference, the only solution I have found as a workaround is to create a filter using the same expression I used for the background colour, except using 'Abbreviation Needed' instead of Red().

Community Browser