Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aniruddhyadutta
Creator
Creator

Qliksense background color expression issue

Hi All,

I have a table like below

Capture.PNG

I want to use a  background color expression as below :If(Count({$<SEVERITY = {'1'}>} Alert_count)>0,LIGHTRED(),YELLOW())

I am getting an extra row which should not come in my understanding

Capture.PNG

I am not able to understand why this extra row is coming. Though the active alert count is zero its still showing red.

Also my original requirement  is like

If severity =1  then red color else( if severity <>1 and Alert Count>0 ) then Yellow else white

can anyone plz help me with the background color expression.

0 Replies