topic Re: Need help with Qlikview KPI Expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690922#M726901 <P>KPI1 : Sum(Distinct ColC)</P><P>KPI2 : Count(DISTINCT ColB)</P> Sat, 04 Apr 2020 05:06:19 GMT Anil_Babu_Samineni 2020-04-04T05:06:19Z Need help with Qlikview KPI Expression https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690921#M726900 <P>Need help in create below two KPI's</P><P>First KPI&nbsp; :&nbsp; &nbsp;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">&nbsp;</TD><TD width="189">&nbsp;</TD></TR><TR><TD>1</TD><TD>123</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>123</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>3</TD><TD>123</TD><TD>$10</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>123</TD><TD>$10</TD><TD>&nbsp;</TD><TD>KPI 1</TD></TR><TR><TD>5</TD><TD>123</TD><TD>$10</TD><TD>&nbsp;</TD><TD>Col c $10+$40</TD></TR><TR><TD>1</TD><TD>444</TD><TD>$40</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>444</TD><TD>$40</TD><TD>&nbsp;</TD><TD>KPI 2</TD></TR><TR><TD>3</TD><TD>444</TD><TD>$40</TD><TD>&nbsp;</TD><TD>Distinct of col b count</TD></TR><TR><TD>4</TD><TD>444</TD><TD>$40</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>5</TD><TD>444</TD><TD>$40</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 00:54:13 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690921#M726900 itsme123 2024-11-16T00:54:13Z Re: Need help with Qlikview KPI Expression https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690922#M726901 <P>KPI1 : Sum(Distinct ColC)</P><P>KPI2 : Count(DISTINCT ColB)</P> Sat, 04 Apr 2020 05:06:19 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690922#M726901 Anil_Babu_Samineni 2020-04-04T05:06:19Z Re: Need help with Qlikview KPI Expression https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690924#M726902 <P>Thank you for quick response</P> Sat, 04 Apr 2020 05:45:25 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Qlikview-KPI-Expression/m-p/1690924#M726902 itsme123 2020-04-04T05:45:25Z