Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to add expression in Add limit
sum({<MonthName={"=$(=Max(MonthName))"}>}sales) > sum({<MonthName={"=$(=Max(MonthName))"}>}sales) red else green
Hi,
try below
if(sum({<MonthName={"=$(=Max(MonthName))"}>}sales) > sum({<MonthName={"=$(=Max(MonthName))"}>}sales) ,Red(),Green())
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
put sum({<MonthName={"=$(=Max(MonthName))"}>}sales) in fx editor.
choose left side color as Red and right as Green
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
try to create a varibale for colour and check below link it will helps you to do