Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Count of cells in a row with specific background color

Hi All,

I have created a table with color by expression. I need to create a column where I can show the count of cells which have red color.

Regards,
Vinayak

Tags (1)
2 Replies
niclaz79
Contributor III

Re: Count of cells in a row with specific background color

Hi, you need to reuse the same expression used to determine the color.

For instance, if your color expression was; if(Value > 1000, RGB(123,123,123), Black())

Your count would be Count(if(Value > 1000, WhatToCount)).

And add Distinct as needed.

Not applicable

Re: Count of cells in a row with specific background color

HI Niclas,

Thanks alot for such a prompt response.
But I have multiple expression for the each cell hence please help me in figuring this out how to use this.

Regards,

Vinayak