topic Streak Value calculation for a KPI in QlikView https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816832#M288047 <HTML><HEAD></HEAD><BODY><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">Hi All,</SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';"><BR /></SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">Any ideas to calculate streak value easily ?<BR /></SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';"><BR /></SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">o</SPAN>&nbsp;&nbsp; <SPAN style="font-family: 'HP Simplified',sans-serif;">We need to calculate a Streak value for each KPI.</SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">o</SPAN>&nbsp;&nbsp; <SPAN style="font-family: 'HP Simplified',sans-serif;">For example we have a KPI that has been green (Better or equal to Goal)&nbsp; for the last 3 weeks then the Streak should be G3.</SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">o</SPAN>&nbsp;&nbsp; <SPAN style="font-family: 'HP Simplified',sans-serif;">Similarly for Red /Yellow. Like bellow:</SPAN> </P><P>&nbsp; <SPAN style="font-size: 11.0pt; font-family: 'Courier New';">o</SPAN></P><P><IMG alt="Streak.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82280_Streak.png" style="height: auto;" /></P><P>Thanks,</P><P>Chiru</P></BODY></HTML> Mon, 30 Mar 2015 03:55:37 GMT chiru_thota 2015-03-30T03:55:37Z Streak Value calculation for a KPI https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816832#M288047 <HTML><HEAD></HEAD><BODY><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">Hi All,</SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';"><BR /></SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">Any ideas to calculate streak value easily ?<BR /></SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';"><BR /></SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">o</SPAN>&nbsp;&nbsp; <SPAN style="font-family: 'HP Simplified',sans-serif;">We need to calculate a Streak value for each KPI.</SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">o</SPAN>&nbsp;&nbsp; <SPAN style="font-family: 'HP Simplified',sans-serif;">For example we have a KPI that has been green (Better or equal to Goal)&nbsp; for the last 3 weeks then the Streak should be G3.</SPAN></P><P style="margin-left: 1.0in; text-indent: -.25in;"><SPAN style="font-family: 'Courier New';">o</SPAN>&nbsp;&nbsp; <SPAN style="font-family: 'HP Simplified',sans-serif;">Similarly for Red /Yellow. Like bellow:</SPAN> </P><P>&nbsp; <SPAN style="font-size: 11.0pt; font-family: 'Courier New';">o</SPAN></P><P><IMG alt="Streak.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82280_Streak.png" style="height: auto;" /></P><P>Thanks,</P><P>Chiru</P></BODY></HTML> Mon, 30 Mar 2015 03:55:37 GMT https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816832#M288047 chiru_thota 2015-03-30T03:55:37Z Re: Streak Value calculation for a KPI https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816833#M288048 <HTML><HEAD></HEAD><BODY><P>Go to properties of the table or chart and under visual clues , you can write the conditions.</P></BODY></HTML> Mon, 30 Mar 2015 04:46:50 GMT https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816833#M288048 agni_gold 2015-03-30T04:46:50Z Re: Streak Value calculation for a KPI https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816834#M288049 <HTML><HEAD></HEAD><BODY><P>Any other Ideas ?</P></BODY></HTML> Mon, 30 Mar 2015 16:28:47 GMT https://community.qlik.com/t5/QlikView/Streak-Value-calculation-for-a-KPI/m-p/816834#M288049 chiru_thota 2015-03-30T16:28:47Z