topic Need to count the zero value columns. in App Development https://community.qlik.com/t5/App-Development/Need-to-count-the-zero-value-columns/m-p/2091544#M89474 <P>Hi All,</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="muhammedraleen_0-1688733129361.png" style="width: 798px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111771iAECAA37A4296129A/image-dimensions/798x92?v=v2" width="798" height="92" role="button" title="muhammedraleen_0-1688733129361.png" alt="muhammedraleen_0-1688733129361.png" /></span></P> <P>In this above table, have values for last 24 months of a customer. Each column is calculated by set analysis using date field.<BR />Customer's need is to count the months where they have no values and display it in the next column.<BR />For an Example: - If we check backwards from current month, how many months consecutively they have zero values.</P> <P>In this case, if we check from Jun 2023 to March 2023, they don't have any values, so in the next column of Jun 2023, customer needs the output as 4.<BR /><BR />Can anyone help me on this...? This wud be great help.</P> Fri, 15 Nov 2024 21:36:33 GMT muhammedraleen 2024-11-15T21:36:33Z Need to count the zero value columns. https://community.qlik.com/t5/App-Development/Need-to-count-the-zero-value-columns/m-p/2091544#M89474 <P>Hi All,</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="muhammedraleen_0-1688733129361.png" style="width: 798px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/111771iAECAA37A4296129A/image-dimensions/798x92?v=v2" width="798" height="92" role="button" title="muhammedraleen_0-1688733129361.png" alt="muhammedraleen_0-1688733129361.png" /></span></P> <P>In this above table, have values for last 24 months of a customer. Each column is calculated by set analysis using date field.<BR />Customer's need is to count the months where they have no values and display it in the next column.<BR />For an Example: - If we check backwards from current month, how many months consecutively they have zero values.</P> <P>In this case, if we check from Jun 2023 to March 2023, they don't have any values, so in the next column of Jun 2023, customer needs the output as 4.<BR /><BR />Can anyone help me on this...? This wud be great help.</P> Fri, 15 Nov 2024 21:36:33 GMT https://community.qlik.com/t5/App-Development/Need-to-count-the-zero-value-columns/m-p/2091544#M89474 muhammedraleen 2024-11-15T21:36:33Z