Discussion board where members can get started with Qlik Sense.
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
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.
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.