Discussion board where members can get started with QlikView.
My data contain five different records to express a percentage value. for instance:
red.perc, yellow.perc and blu.perc are float numbers such that red.perc+yellow.perc+blu.perc=1
I would then like to create a pie chart that has as dimension the colors and has expression the average of each one.
Which solution would you suggest?
Go to Solution.
you can load your values like this:
'RED' AS COLOR_NAME
red.perc AS PERC
'BLUE' AS COLOR_NAME
blue.perc AS PERC
then you can use the pie chart, with "COLOR_NAME" as dimension, and AVG(PERC) as expression.
a dimensionless pie chart with five avg(...) expressions