Highlighting in Pivot Table with calculated Measure
I now have to build some existing QV dashboards into Qlik Sense. Thankfully the transition has been quite painless, but I cannot figure out how to formulate the highlight option in a calculated measure.
I am using:
If([Assessment (Done or Planned)]= 0.2, RGB(0,105,60))
and getting a generic error (attached)
What I would like to do is highlight cells one color if <50% and another between 50-99 and the third color if =100%.