Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mhmmd_srf
Contributor II

Percentage & Color Coding in Qlikview Text Object

Hi All,

I need to show Sum(Sales)/Sum(Planned) in a single KPI.

I build this through Text Object. Need two things.

1. The value is showing like 53.565758598. We need this two decimal point.

2. We need to show color coding. Like below 50 red and above 50 green.

In other chart both are possible. But how can I implement this in Text Object.

Please help.

Thanks,

Sarif

4 Replies
stabben23
Honored Contributor

Re: Percentage & Color Coding in Qlikview Text Object

Hi,

you need to use num in a text Object, like this.

num(sum(Sales)/sum(Planned)*100,'##,##')& ' %'

and in color code, use calculated color in Font tab like this.

if(sum(Sales)/sum(Planned)>50,Green(),lightRed())

nivetha40
New Contributor III

Re: Percentage & Color Coding in Qlikview Text Object

Hi Mohammad,

1.Regarding coloring, Use the below if condition in the Red highlighted area of screenshot.

      if(sum(Sales)/sum(Planned)>50,Green(),Red())

Image.png

2.And use the Num function for Decimal point.

priyasawant
Contributor

Re: Percentage & Color Coding in Qlikview Text Object

Hi kindly go to Font and select colour and mention the calculated condition of colour as per your requirement

sum(sales)/ sum(planned) in the text box

=if(sum(sales)/ sum(planned) <=50,Red(),Green())

colour.JPG

Partner
Partner

Re: Percentage & Color Coding in Qlikview Text Object

Hi,

refer this app,

Muthukumar Pandiyan