topic issue in Count Calculation in QlikView https://community.qlik.com/t5/QlikView/issue-in-Count-Calculation/m-p/158586#M33603 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I am having the below expression in the Text object.</P><P>='Closed calls :'&amp; <B>num</B>(<B>count</B>(<B>distinct</B> <B>if</B>(CloseFromdate&gt;=<B>From_date</B> <B>and</B> <B>Closetodate</B>&lt;=<B>To_Date</B> <B>and</B> (<B>Status_Flag</B>='Closed' ),I<B>D</B>)),'#,##,###')</P><P>It is not showing any values. But if keep a list box with Status_flag and choose the status as closed then it is displaying the closed count.</P><P>I have the similar expression for open it is working fine without the list box selection?</P><P>Any suggestions please</P></BODY></HTML> Fri, 07 Jan 2011 07:20:56 GMT 2011-01-07T07:20:56Z issue in Count Calculation https://community.qlik.com/t5/QlikView/issue-in-Count-Calculation/m-p/158586#M33603 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I am having the below expression in the Text object.</P><P>='Closed calls :'&amp; <B>num</B>(<B>count</B>(<B>distinct</B> <B>if</B>(CloseFromdate&gt;=<B>From_date</B> <B>and</B> <B>Closetodate</B>&lt;=<B>To_Date</B> <B>and</B> (<B>Status_Flag</B>='Closed' ),I<B>D</B>)),'#,##,###')</P><P>It is not showing any values. But if keep a list box with Status_flag and choose the status as closed then it is displaying the closed count.</P><P>I have the similar expression for open it is working fine without the list box selection?</P><P>Any suggestions please</P></BODY></HTML> Fri, 07 Jan 2011 07:20:56 GMT https://community.qlik.com/t5/QlikView/issue-in-Count-Calculation/m-p/158586#M33603 2011-01-07T07:20:56Z