pie chart output with calculated expression

aj0031724 — Mon, 07 Sep 2015 07:52:17 GMT

Dear Team,

I need to use expression as below to show

Pie Chart of percentage breakdown to Alarmed Cells, Highly Utilized Cells, Standard Cells and Low Utilized cells based on filtered KPI and date.

=if(Above($(vkpivalue))>4 and Above($(vkpivalue),0)>4,'Alarmed',
if(-rangesum(($(vkpivalue)>4),(Above($(vkpivalue),1)>4),(Above($(vkpivalue),2)>4),(Above($(vkpivalue),3)>4),(Above($(vkpivalue),4)>4),(Above($(vkpivalue),5)>4),(Above($(vkpivalue),6)>4))>=4,'Highly utilized',
if(-rangesum(($(vkpivalue)<3),(Above($(vkpivalue),1)<3),(Above($(vkpivalue),2)<3),(Above($(vkpivalue),3)<3),(Above($(vkpivalue),4)<3),(Above($(vkpivalue),5)<3),(Above($(vkpivalue),6)<3))>=6,'Low utilized',
'Standard')))

For example the straight table Classification output is showing "CELL C1 ->KPI->K1-->date->16/08/2015--as ""HIGHLY UTILIZED"".

Pie chart output should show the classification of CELLS per KPI and date in percentage i"e 100% HIGHLY UTILIZED FOR date ->16/08/2015.

How can I use the above expression for Pie chart calculation percentage.

Please suggest.

PFA the sampel qvw I am woring on.

topic pie chart output with calculated expression in QlikView

pie chart output with calculated expression