Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aj0031724
Partner - Creator
Partner - Creator

pie chart output with calculated expression

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.

0 Replies