Hello All,
I am trying to get conditional background colour in qlik sense.but my two expressions are not compairing correctly.
Kindly advice .what to do?
below is the expression
set analysis:
if(KPI_Type='Actual' and Round(sum({<KPI_Type={'Actual'}>}Value))>Round(sum({<KPI_Type={'Target'}>}Value)), '#00ff99',
if(KPI_Type='Actual' and Round(sum({<KPI_Type={'Actual'}>}Value))<Round(sum({<KPI_Type={'Target'}>}Value)), '#ff9999',
if(KPI_Type='Actual' and (Round(sum({<KPI_Type={'Actual'}>}Value))='0'), '#c2cbcb'))
)
