KPI in Qlik Sense

[sivasiri99]

Hi All,

I need to add expression in Add limit

sum({<MonthName={"=$(=Max(MonthName))"}>}sales) > sum({<MonthName={"=$(=Max(MonthName))"}>}sales) red else green

[Chanty4u]

Hi,

try below

if(sum({<MonthName={"=$(=Max(MonthName))"}>}sales) > sum({<MonthName={"=$(=Max(MonthName))"}>}sales) ,Red(),Green())

[sivasiri99]

Hi

Tq for respon's this won't work in Qlik Sense

I need that three based on the sum of sales

I need to achive this colors based on expression if

[shraddha_g]

put sum({<MonthName={"=$(=Max(MonthName))"}>}sales) in fx editor.

choose left side color as Red and right as Green

[sivasiri99]

Thanks

It is not working

if sales of last month is greater than current month then it should be in red,else green

plese send me the qvf file it will help me

[Chanty4u]

try to create a varibale for colour and  check below link it will helps you to do

BG color expression with set analysis?