Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Issue in KPI coloring

Hi,

I am trying to use expression to color the results, but it seems like its not working.

please advise if i am doing something wrong here (please refer the screen shotCapture.JPG

I have an expression as below for one of my KPI

round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

/

(sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

{$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01)

and for coloring i am using the below

if((round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

/

(sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

{$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01))<.90,red(),green())

3 Replies

Re: Issue in KPI coloring

Hi,

Instead of expression you can you just try 0.90 as expression. and click the block above that to color that.

See images.

Capture.PNG

Capture1.PNG

Regards,

Kaushik Solanki

MVP
MVP

Re: Issue in KPI coloring

HI,

Try  this

if((round(((sum({<fReportMetricKeyId={'1'},fMonthCD={$(=min(fMonthCD))}>}fCallAnsweredBeforeThreshold)

/

(sum({<fReportMetricKeyId={'1'}, fMonthCD={$(=min(fMonthCD))}>}fCallOffered)-sum({<fReportMetricKeyId={'1'}, fMonthCD=

{$(=Min(fMonthCD))}>}fFalseAttempts)))),0.01))< 0.90,red(),green())

Regards,

Jagan.

reddys310
Honored Contributor II

Re: Issue in KPI coloring

Hi Prasantha,

Is it possible to share a samlpe QVF?

Thanks,

Sangram.