https://community.qlik.com/t5/QlikView/alert-about-no-data-after-days-in-the-text-box/m-p/1937289#M1219207 <P>Hi! Try this</P> <P>='There is '&amp;Count({$&lt;Flag = {0} &gt; } Data)&amp;' days with no sales:'&amp;Chr(10)&amp;Chr(10)&amp;Concat({$&lt;Flag = {0} &gt; } Data, ', ')</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="antose_0-1653920358498.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80634i4FB85A7911F72AC3/image-size/medium?v=v2&amp;px=400" role="button" title="antose_0-1653920358498.png" alt="antose_0-1653920358498.png" /></span></P> <P>&nbsp;</P> Mon, 30 May 2022 14:20:22 GMT antose 2022-05-30T14:20:22Z https://community.qlik.com/t5/QlikView/alert-about-no-data-after-days-in-the-text-box/m-p/1936908#M1219194 <P>Hi,</P> <P>I need create text box, where I have information, <SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="pl" data-phrase-index="0" data-number-of-phrases="1"><SPAN class="Q4iAWc">which days we have no sale</SPAN></SPAN></SPAN>. <SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="pl" data-phrase-index="0" data-number-of-phrases="1"><SPAN class="Q4iAWc">I need it to verify the correctness of the data</SPAN></SPAN></SPAN>.</P> <P>Example:</P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="pl" data-phrase-index="0" data-number-of-phrases="1"><SPAN class="Q4iAWc">We have tables with 3 columns: date, sale and flag (1- sale, 0 - no sale). I tried to write a text box via the if function. <BR /></SPAN></SPAN></SPAN></P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="pl" data-phrase-index="0" data-number-of-phrases="1"><SPAN class="Q4iAWc">Expected result in textbox: no data: 2022-05-03, 2022-05-05, 2022-05-08<BR /></SPAN></SPAN></SPAN></P> <TABLE width="231"> <TBODY> <TR> <TD width="74">Data</TD> <TD width="93">Sales</TD> <TD width="64">Flag</TD> </TR> <TR> <TD>2022-05-01</TD> <TD>5647,0</TD> <TD>1</TD> </TR> <TR> <TD>2022-05-02</TD> <TD>736464,0</TD> <TD>1</TD> </TR> <TR> <TD>2022-05-03</TD> <TD>0,0</TD> <TD>0</TD> </TR> <TR> <TD>2022-05-04</TD> <TD>7564,0</TD> <TD>1</TD> </TR> <TR> <TD>2022-05-05</TD> <TD>0,0</TD> <TD>0</TD> </TR> <TR> <TD>2022-05-06</TD> <TD>4264746,0</TD> <TD>1</TD> </TR> <TR> <TD>2022-05-07</TD> <TD>6743,0</TD> <TD>1</TD> </TR> <TR> <TD>2022-05-08</TD> <TD>0,0</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P><SPAN class="VIiyi"><SPAN class="JLqJ4b ChMk0b" data-language-for-alternatives="en" data-language-to-translate-into="pl" data-phrase-index="0" data-number-of-phrases="1"><SPAN class="Q4iAWc">thank you for any advice</SPAN></SPAN></SPAN> <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sun, 29 May 2022 11:54:09 GMT https://community.qlik.com/t5/QlikView/alert-about-no-data-after-days-in-the-text-box/m-p/1936908#M1219194 Isabelaa_123 2022-05-29T11:54:09Z https://community.qlik.com/t5/QlikView/alert-about-no-data-after-days-in-the-text-box/m-p/1937289#M1219207 <P>Hi! Try this</P> <P>='There is '&amp;Count({$&lt;Flag = {0} &gt; } Data)&amp;' days with no sales:'&amp;Chr(10)&amp;Chr(10)&amp;Concat({$&lt;Flag = {0} &gt; } Data, ', ')</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="antose_0-1653920358498.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/80634i4FB85A7911F72AC3/image-size/medium?v=v2&amp;px=400" role="button" title="antose_0-1653920358498.png" alt="antose_0-1653920358498.png" /></span></P> <P>&nbsp;</P> Mon, 30 May 2022 14:20:22 GMT https://community.qlik.com/t5/QlikView/alert-about-no-data-after-days-in-the-text-box/m-p/1937289#M1219207 antose 2022-05-30T14:20:22Z