0 Replies Latest reply: Apr 5, 2017 2:14 PM by Aniruddhya Dutta RSS

    Qliksense background color expression issue

    Aniruddhya Dutta

      Hi All,

      I have a table like below



      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


      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.