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?