Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sivasiri99
New Contributor III

KPI in Qlik Sense

Hi All,

I need to add expression in Add limit

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

Tags (1)
5 Replies
sureshqv
Esteemed Contributor III

Re: KPI in Qlik Sense

Hi,

try below

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

sivasiri99
New Contributor III

Re: KPI in Qlik Sense

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
Honored Contributor III

Re: KPI in Qlik Sense

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

choose left side color as Red and right as Green

sivasiri99
New Contributor III

Re: KPI in Qlik Sense

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

sureshqv
Esteemed Contributor III

Re: KPI in Qlik Sense

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

BG color expression with set analysis?

Community Browser