topic Total Count of Rows expression with Alternate State in QlikView https://community.qlik.com/t5/QlikView/Total-Count-of-Rows-expression-with-Alternate-State/m-p/396219#M485228 <HTML><HEAD></HEAD><BODY><P>I'm trying to replicate the formula or expression of <STRONG>Total mode "Total Count of rows"</STRONG></P><P></P><P>I would like to use it in other locations vs just the once spot where it shows. Is this possible?</P><P></P><P>I've tried : <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">='Projects - A&nbsp; '&amp;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">( </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">TOTAL</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> {</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Alternate_A</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&nbsp; } </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Project</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)&nbsp; with no luck. </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Its suppose to be 1342 but I 462 For list 'A' and 1568 for B.</SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">I believe without Alternate States this would work fine what else should I add? </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Guesses are welcome<BR /></SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><IMG __jive_id="39659" alt="2013-04-24_101344.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39659_2013-04-24_101344.png" width="450" /><BR /></SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P></BODY></HTML> Wed, 24 Apr 2013 14:21:02 GMT 2013-04-24T14:21:02Z Total Count of Rows expression with Alternate State https://community.qlik.com/t5/QlikView/Total-Count-of-Rows-expression-with-Alternate-State/m-p/396219#M485228 <HTML><HEAD></HEAD><BODY><P>I'm trying to replicate the formula or expression of <STRONG>Total mode "Total Count of rows"</STRONG></P><P></P><P>I would like to use it in other locations vs just the once spot where it shows. Is this possible?</P><P></P><P>I've tried : <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">='Projects - A&nbsp; '&amp;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">( </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">TOTAL</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> {</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">Alternate_A</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">&nbsp; } </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">Project</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">)&nbsp; with no luck. </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Its suppose to be 1342 but I 462 For list 'A' and 1568 for B.</SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">I believe without Alternate States this would work fine what else should I add? </SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Guesses are welcome<BR /></SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><IMG __jive_id="39659" alt="2013-04-24_101344.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39659_2013-04-24_101344.png" width="450" /><BR /></SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P></BODY></HTML> Wed, 24 Apr 2013 14:21:02 GMT https://community.qlik.com/t5/QlikView/Total-Count-of-Rows-expression-with-Alternate-State/m-p/396219#M485228 2013-04-24T14:21:02Z