Background Color Expression - Qlik Sense

[hammermill21]

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!

[OmarBenSalem]

Glad to help;

Don't you forget to close this thread then by makring the correct answer as so and the helpful one as helpful (under actions)

Have a nice day

[sanket94]

What if I need only top 5 values of particular column