Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Consolidating data to new chart type

Hello,

I'm not sure if the below is possible but thought I'd ask for some suggestions. I have a number of KPIs that are used across a number of different sites and all of which have their own targets, on which a RAG status is calculated. What I require is, that rather than the KPIs being displayed in a table format with their RAG colour beside them, all of the RAG statuses are consolidated into a Pie Chart with it simply showing the breakdown of the RAGs, e.g. 50% of the KPIs are green and this is shown with a pie chart being broken up to display half of it green.

The current chart has variables in it so that end users can select particularly weeks to see the spread across differents sites. We have 4 sites and I would want to see 4 different pie charts showing their respective RAG statuses.

Let me know if you require any further information.

Thanks,

Ralph

KPIDataRAG
Sales30Red
Profit35Green
Attendance2Green
CoS34

Amber

Accidents4Red
Share32Green
Tags (2)
4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Consolidating data to new chart type

You can use the trellis option to display a pie chart for every site. So site is one dimension, RAG is the second dimension. And count(KPI) is the expression.

You can use this expression for the background color of the expression to set the color of the pie segments: pick(match(RAG,'Red','Green','Amber'),LightRed(),LightGreen(),RGB(255,155,0))


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Consolidating data to new chart type

RAG is calculated based on the Data. i.e. for the above example for Sales, the target is 25 and that is why it is showing up as a RAG status of Green. Would that work as a calculated dimensions?

Thanks,

Ralph

Highlighted
MVP & Luminary
MVP & Luminary

Re: Consolidating data to new chart type

The expression you use to calculate RAG should work as a calculated dimension.


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Consolidating data to new chart type

Hello,

For information, below you can see how I currently attach a RAG status against each KPI. I'm not sure this can be added as a second dimension as each KPI has a different method to calculate the RAG status

"

=

if(sum({<Site={"Dublin"},Week={$(=vCurrentWeek)}>}[Sales]) >
avg({<Site={"Dublin"},KPI={"Sales"}>}Base),'red',



if(sum({<Site={"Dublin"},Week={$(=vCurrentWeek)}>}Sales]) <

avg({<Site={"Dublin"},KPI={"Sales"}>}Target), 'green', 'orange'))
"