topic Re: Value group by KPI in QlikView

topic Re: Value group by KPI in QlikView https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012347#M958044 <HTML><HEAD></HEAD><BODY><P>Try avg({<[Val KPI]={">0"}>}total [Val KPI])</P></BODY></HTML> Tue, 03 Nov 2015 10:03:58 GMT Gysbert_Wassenaar 2015-11-03T10:03:58Z Value group by KPI https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012346#M958043 <HTML><HEAD></HEAD><BODY><P>Hi mates!</P><P></P><P>I got this table:</P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" width="398"><TBODY><TR><TD class="xl63" height="17" width="82">DATO</TD><TD class="xl63" style="border-left: none;" width="88">KPI</TD><TD class="xl63" style="border-left: none;" width="103">VAL DATO</TD><TD class="xl63" style="border-left: none;" width="125">VAL KPI</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">D.001.K6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">D.001</TD><TD class="xl64" style="border-top: none; border-left: none;">Gar_5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">99,2205%</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>-</P></TD></TR></TBODY></TABLE><P></P><P>Now I´m getting VAL DATO as the average of all values of VAL KPI (without null values). </P><P>I want to get the average of these values by KPI <SPAN style="font-size: 13.3333px;">(without null values), the table will be like this:</SPAN></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD class="xl65" height="17" width="80">DATO</TD><TD class="xl65" style="border-left: none;" width="80">KPI</TD><TD class="xl65" style="border-left: none;" width="80">VAL DATO</TD><TD class="xl65" style="border-left: none;" width="80">VAL KPI</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,4679%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">98,9989%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100,0000%</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">D.001.K6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">D.001</TD><TD class="xl66" style="border-top: none; border-left: none;">Gar_5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">99,3667%</TD><TD class="xl67" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE><P></P><P>Thank you very much guys!!</P></BODY></HTML> Tue, 03 Nov 2015 08:39:47 GMT https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012346#M958043 2015-11-03T08:39:47Z Re: Value group by KPI https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012347#M958044 <HTML><HEAD></HEAD><BODY><P>Try avg({<[Val KPI]={">0"}>}total [Val KPI])</P></BODY></HTML> Tue, 03 Nov 2015 10:03:58 GMT https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012347#M958044 Gysbert_Wassenaar 2015-11-03T10:03:58Z Re: Value group by KPI https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012348#M958045 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert, </P><P>Sorry but I'm trying to do it on Script, is it possible?</P><P></P><P>Thanks again.</P></BODY></HTML> Tue, 03 Nov 2015 10:10:14 GMT https://community.qlik.com/t5/QlikView/Value-group-by-KPI/m-p/1012348#M958045 2015-11-03T10:10:14Z