topic Count Consecutive Zero values in Pivot in QlikView https://community.qlik.com/t5/QlikView/Count-Consecutive-Zero-values-in-Pivot/m-p/1190210#M883663 <HTML><HEAD></HEAD><BODY><P>I would like to get the count of consecutive zero values in a pivot table like below. Based on the count I would be setting a status.</P><P></P><P>The conditions are:</P><OL><LI>For a period selected there should be some values before and after the consecutive zeros.</LI><LI>Count of consecutive zeros should be greater than or equal to 3.</LI></OL><P></P><P>Please refer the snapshot attached. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Count Consecutive Zero values in Pivot https://community.qlik.com/t5/QlikView/Count-Consecutive-Zero-values-in-Pivot/m-p/1190210#M883663 <HTML><HEAD></HEAD><BODY><P>I would like to get the count of consecutive zero values in a pivot table like below. Based on the count I would be setting a status.</P><P></P><P>The conditions are:</P><OL><LI>For a period selected there should be some values before and after the consecutive zeros.</LI><LI>Count of consecutive zeros should be greater than or equal to 3.</LI></OL><P></P><P>Please refer the snapshot attached. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-Consecutive-Zero-values-in-Pivot/m-p/1190210#M883663 2020-11-25T16:16:04Z