topic Re: In Script - group percentage values in QlikView

In Script - group percentage values

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

My data contain five different records to express a percentage value. for instance:

MyTable

Load Id,

red.perc,

yellow.perc,

blu.perc,

...

FROM ....

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?

Thu, 26 Nov 2015 16:50:39 GMT

Hi Giusy,

you can load your values like this:

Table

Load Id,

'RED' AS COLOR_NAME

red.perc AS PERC

...

FROM ....

JOIN

Load Id,

'BLUE' AS COLOR_NAME

blue.perc AS PERC

...

FROM ....

then you can use the pie chart, with "COLOR_NAME" as dimension, and AVG(PERC) as expression.

maxgro — Thu, 26 Nov 2015 18:34:01 GMT

a dimensionless pie chart with five avg(...) expressions