topic Re: KPI in QlikView https://community.qlik.com/t5/QlikView/KPI/m-p/1452928#M434672 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P><STRONG>=FirstSortedValue(story, -Aggr(Count(substory), story))</STRONG></P></BODY></HTML> Mon, 16 Oct 2017 11:20:19 GMT Anil_Babu_Samineni 2017-10-16T11:20:19Z KPI https://community.qlik.com/t5/QlikView/KPI/m-p/1452927#M434671 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><TABLE border="0" cellspacing="0"><TBODY><TR><TD align="left" height="20" valign="bottom"><SPAN style="color: #000000;"><STRONG>story</STRONG></SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;"><STRONG>substory</STRONG></SPAN></TD></TR><TR><TD align="left" height="17" valign="bottom"><SPAN style="color: #000000;">story1</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory1</SPAN></TD></TR><TR><TD align="left" height="17" valign="bottom"><SPAN style="color: #000000;">story1</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory2</SPAN></TD></TR><TR><TD align="left" height="17" valign="bottom"><SPAN style="color: #000000;">story1</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory3</SPAN></TD></TR><TR><TD align="left" height="17" valign="bottom"><SPAN style="color: #000000;">story2</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory1</SPAN></TD></TR><TR><TD align="left" height="17" valign="bottom"><SPAN style="color: #000000;">story2</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory3</SPAN></TD></TR><TR><TD align="left" height="17" valign="bottom"><SPAN style="color: #000000;">story2</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory2</SPAN></TD></TR><TR><TD align="left" height="20" valign="bottom"><SPAN style="color: #000000;">story2</SPAN></TD><TD align="left" valign="bottom"><SPAN style="color: #000000;">substory4</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>i want story name in KPI front end. which is having max no. of sub stories.</P><P></P><P>Thanks &amp; Regards</P></BODY></HTML> Mon, 16 Oct 2017 11:12:12 GMT https://community.qlik.com/t5/QlikView/KPI/m-p/1452927#M434671 Anonymous 2017-10-16T11:12:12Z Re: KPI https://community.qlik.com/t5/QlikView/KPI/m-p/1452928#M434672 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P><STRONG>=FirstSortedValue(story, -Aggr(Count(substory), story))</STRONG></P></BODY></HTML> Mon, 16 Oct 2017 11:20:19 GMT https://community.qlik.com/t5/QlikView/KPI/m-p/1452928#M434672 Anil_Babu_Samineni 2017-10-16T11:20:19Z Re: KPI https://community.qlik.com/t5/QlikView/KPI/m-p/1452929#M434673 <HTML><HEAD></HEAD><BODY><P>What would you want to see if two stories have same number of substories? Would you want to see one of them randomly? You can try this</P><P></P><P><STRONG>=FirstSortedValue(<SPAN style="color: #ff0000;">DISTINCT</SPAN> story, -Aggr(Count(substory), story))</STRONG></P><P></P><P>See both separated by comma?</P><P></P><P><STRONG>=Concat(DISTINCT Aggr(If(Count(substory) = Max(TOTAL Aggr(Count(substory), story)), story), story))</STRONG></P></BODY></HTML> Mon, 16 Oct 2017 12:00:50 GMT https://community.qlik.com/t5/QlikView/KPI/m-p/1452929#M434673 sunny_talwar 2017-10-16T12:00:50Z