topic Need help with Qlikview KPI Expression in New to QlikView
https://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690921#M387922
<P>Need help in create below two KPI's</P><P>First KPI : column b 123 has amount $10 and 444 has $40 i just need to pick distinct value of col b and there respective amount to be sum $10 +$40 = 50 this should be my KPI result</P><P>Second KPI : I need distinct count of col b = 2 should be my KPI result</P><TABLE width="445"><TBODY><TR><TD width="64">ColA</TD><TD width="64">ColB</TD><TD width="64">ColC</TD><TD width="64"> </TD><TD width="189"> </TD></TR><TR><TD>1</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD> </TD></TR><TR><TD>3</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD> </TD></TR><TR><TD>4</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD>KPI 1</TD></TR><TR><TD>5</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD>Col c $10+$40</TD></TR><TR><TD>1</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD>KPI 2</TD></TR><TR><TD>3</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD>Distinct of col b count</TD></TR><TR><TD>4</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD> </TD></TR><TR><TD>5</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Sat, 04 Apr 2020 04:44:59 GMTitsme1232020-04-04T04:44:59ZNeed help with Qlikview KPI Expression
https://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690921#M387922
<P>Need help in create below two KPI's</P><P>First KPI : column b 123 has amount $10 and 444 has $40 i just need to pick distinct value of col b and there respective amount to be sum $10 +$40 = 50 this should be my KPI result</P><P>Second KPI : I need distinct count of col b = 2 should be my KPI result</P><TABLE width="445"><TBODY><TR><TD width="64">ColA</TD><TD width="64">ColB</TD><TD width="64">ColC</TD><TD width="64"> </TD><TD width="189"> </TD></TR><TR><TD>1</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD> </TD></TR><TR><TD>3</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD> </TD></TR><TR><TD>4</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD>KPI 1</TD></TR><TR><TD>5</TD><TD>123</TD><TD>$10</TD><TD> </TD><TD>Col c $10+$40</TD></TR><TR><TD>1</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD> </TD></TR><TR><TD>2</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD>KPI 2</TD></TR><TR><TD>3</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD>Distinct of col b count</TD></TR><TR><TD>4</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD> </TD></TR><TR><TD>5</TD><TD>444</TD><TD>$40</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Sat, 04 Apr 2020 04:44:59 GMThttps://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690921#M387922itsme1232020-04-04T04:44:59ZRe: Need help with Qlikview KPI Expression
https://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690922#M387923
<P>KPI1 : Sum(Distinct ColC)</P><P>KPI2 : Count(DISTINCT ColB)</P>Sat, 04 Apr 2020 05:06:19 GMThttps://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690922#M387923Anil_Babu_Samineni2020-04-04T05:06:19ZRe: Need help with Qlikview KPI Expression
https://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690924#M387924
<P>Thank you for quick response</P>Sat, 04 Apr 2020 05:45:25 GMThttps://community.qlik.com/t5/New-to-QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690924#M387924itsme1232020-04-04T05:45:25Z