Discussion board where members can get started with QlikView.
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.
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.
1.Regarding coloring, Use the below if condition in the Red highlighted area of screenshot.
2.And use the Num function for Decimal point.
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())
refer this app,