10 Replies Latest reply: Apr 6, 2017 9:34 AM by omar bensalem RSS

    Background Color Expression - Qlik Sense

    Elizabeth Viso

      Hello, everyone-

       

      I am trying to change the background color to a column in a table, I have it working for two colors using this expression:

       

      Count(Distinct [Inspection Bar Code])/$(fInventoryCount]<.50, RED(), Yellow()

       

      But I want to add also if it's over .70 to be blue and if it = 0 to be black. Yet everytime i try to add to the expression it stops working.

       

      Any ideas?

       

      Thanks!