Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Table Alert (Green and Red)

Hi

I have table report like

Year,Total Sales.

If sales >3000 means then my record should display red cell else green.

How can i achieve this.

Thanks

Govind R

1 Solution

Accepted Solutions

Re: Table Alert (Green and Red)

In the expression properties >> click on Plus sign >> and in the Background Properties >> write expression (=If( sales >3000, Red(),Green())

Regards

Anand

3 Replies
arulsettu
Honored Contributor III

Re: Table Alert (Green and Red)

try this

if(sum(sales)>3000,red(),green())

Not applicable

Re: Table Alert (Green and Red)

It showing like RGB....not showing color

Re: Table Alert (Green and Red)

In the expression properties >> click on Plus sign >> and in the Background Properties >> write expression (=If( sales >3000, Red(),Green())

Regards

Anand