topic Count like pivot table in QlikView https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354577#M131602 <HTML><HEAD></HEAD><BODY><P>Count like pivot table</P><P></P><P>I have the following data:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: -1.15pt; padding: 0pt 5.4pt; width: 217px;"><TBODY><TR><TD nowrap="nowrap" style="background-color: whitesmoke; border-width: 1pt 1pt medium; border-style: solid solid none; border-color: gainsboro gainsboro -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><STRONG style="color: #333333; font-size: 10pt; font-family: 'Tahoma','sans-serif';">Item</STRONG></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: whitesmoke; border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: gainsboro gainsboro -moz-use-text-color -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119">in stock</TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border: 1pt solid windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">A</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P>B</P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">C</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">D</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">E</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">F</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AB</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AC</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AD</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AE</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P>B</P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">B1</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">B2</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">B3</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P>I like to count how many items I have for each count</P><P></P><P>This is my expected output</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: medium none; padding: 0pt 5.4pt;"><TBODY><TR><TD nowrap="nowrap" style="border: 1pt solid windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>Count of Item</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>in stock</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>Total</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>1</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>10498</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>2</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>153</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>3</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>5</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>4</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>3</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>(blank)</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>Grand Total</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>10659</P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P>It’s easy using excel, I like to do the same on the QV.</P><P></P><P>Suggestions are more than welcome.</P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 15 Mar 2012 15:09:30 GMT 2012-03-15T15:09:30Z Count like pivot table https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354577#M131602 <HTML><HEAD></HEAD><BODY><P>Count like pivot table</P><P></P><P>I have the following data:</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: -1.15pt; padding: 0pt 5.4pt; width: 217px;"><TBODY><TR><TD nowrap="nowrap" style="background-color: whitesmoke; border-width: 1pt 1pt medium; border-style: solid solid none; border-color: gainsboro gainsboro -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><STRONG style="color: #333333; font-size: 10pt; font-family: 'Tahoma','sans-serif';">Item</STRONG></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: whitesmoke; border-width: 1pt 1pt medium medium; border-style: solid solid none none; border-color: gainsboro gainsboro -moz-use-text-color -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119">in stock</TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border: 1pt solid windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">A</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P>B</P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">C</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">4</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">D</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">E</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">F</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AB</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AC</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">3</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AD</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">AE</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P>B</P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">B1</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">B2</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="bottom" width="99"><P><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">B3</SPAN></P>&nbsp; </TD><TD nowrap="nowrap" style="background-color: white; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="bottom" width="119"><P align="right"><SPAN style="color: #333333; font-family: 'Tahoma','sans-serif'; font-size: 10pt;">2</SPAN></P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P>I like to count how many items I have for each count</P><P></P><P>This is my expected output</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: medium none; padding: 0pt 5.4pt;"><TBODY><TR><TD nowrap="nowrap" style="border: 1pt solid windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>Count of Item</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>in stock</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>Total</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>1</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>10498</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>2</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>153</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>3</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>5</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>4</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>3</P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>(blank)</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P></P>&nbsp; </TD></TR><TR><TD nowrap="nowrap" style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0pt 5.4pt;" valign="top" width="139"><P>Grand Total</P>&nbsp; </TD><TD nowrap="nowrap" style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0pt 5.4pt;" valign="top" width="43"><P>10659</P>&nbsp; </TD></TR></TBODY></TABLE><P></P><P>It’s easy using excel, I like to do the same on the QV.</P><P></P><P>Suggestions are more than welcome.</P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 15 Mar 2012 15:09:30 GMT https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354577#M131602 2012-03-15T15:09:30Z Re: Count like pivot table https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354578#M131603 <HTML><HEAD></HEAD><BODY><P>HERE YOU GO</P></BODY></HTML> Thu, 15 Mar 2012 15:38:51 GMT https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354578#M131603 jvitantonio 2012-03-15T15:38:51Z Count like pivot table https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354579#M131604 <HTML><HEAD></HEAD><BODY><P>is the in stock an expression? You could try aggr like </P><P></P><P>count(aggr(sum(instock),Item))</P></BODY></HTML> Thu, 15 Mar 2012 15:39:02 GMT https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354579#M131604 2012-03-15T15:39:02Z Re: Count like pivot table https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354580#M131605 <HTML><HEAD></HEAD><BODY><P>thank you both.</P></BODY></HTML> Thu, 15 Mar 2012 16:27:22 GMT https://community.qlik.com/t5/QlikView/Count-like-pivot-table/m-p/354580#M131605 2012-03-15T16:27:22Z