topic Count in Pivot table. in QlikView https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310104#M407364 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a scenario where i want my pivot table to show count as shown in the pic.</P><P>Date:</P><TABLE border="1px" cellpadding="0" cellspacing="0" height="324" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border-width: 1px; border-style: solid; width: 173px; height: 267px;" width="171"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">Name</TD><TD width="64">Month</TD><TD width="64">flag</TD></TR><TR><TD align="right" height="20">1</TD><TD>q</TD><TD>Jan</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>a</TD><TD>Jan</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">3</TD><TD>z</TD><TD>Jan</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">4</TD><TD>x</TD><TD>Jan</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">1</TD><TD>q</TD><TD>Feb</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>a</TD><TD>Feb</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">3</TD><TD>z</TD><TD>Feb</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">4</TD><TD>x</TD><TD>Feb</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">1</TD><TD>q</TD><TD>Mar</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>a</TD><TD>Mar</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">3</TD><TD>z</TD><TD>Mar</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">4</TD><TD>x</TD><TD>Mar</TD><TD align="right">0</TD></TR></TBODY></TABLE><P></P><P>I am putting a green check image where ever flag=1 and i count i want to count number of flags for each month. I am pivoting the table on Month column.</P></BODY></HTML> Sun, 18 Jun 2017 07:15:57 GMT Anonymous 2017-06-18T07:15:57Z Count in Pivot table. https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310104#M407364 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a scenario where i want my pivot table to show count as shown in the pic.</P><P>Date:</P><TABLE border="1px" cellpadding="0" cellspacing="0" height="324" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="border-width: 1px; border-style: solid; width: 173px; height: 267px;" width="171"><TBODY><TR><TD height="20" width="64">ID</TD><TD width="64">Name</TD><TD width="64">Month</TD><TD width="64">flag</TD></TR><TR><TD align="right" height="20">1</TD><TD>q</TD><TD>Jan</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>a</TD><TD>Jan</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">3</TD><TD>z</TD><TD>Jan</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">4</TD><TD>x</TD><TD>Jan</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">1</TD><TD>q</TD><TD>Feb</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>a</TD><TD>Feb</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">3</TD><TD>z</TD><TD>Feb</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">4</TD><TD>x</TD><TD>Feb</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">1</TD><TD>q</TD><TD>Mar</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">2</TD><TD>a</TD><TD>Mar</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">3</TD><TD>z</TD><TD>Mar</TD><TD align="right">0</TD></TR><TR><TD align="right" height="20">4</TD><TD>x</TD><TD>Mar</TD><TD align="right">0</TD></TR></TBODY></TABLE><P></P><P>I am putting a green check image where ever flag=1 and i count i want to count number of flags for each month. I am pivoting the table on Month column.</P></BODY></HTML> Sun, 18 Jun 2017 07:15:57 GMT https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310104#M407364 Anonymous 2017-06-18T07:15:57Z Re: Count in Pivot table. https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310105#M407365 <HTML><HEAD></HEAD><BODY><P><EM>Expression:</EM></P><P></P><P><STRONG><EM>=if(Dimensionality()=0,Sum(flag), if(sum(flag)=1,'qmem://&lt;bundled&gt;/BuiltIn/check_g.png'))</EM></STRONG></P><P><STRONG><EM><BR /></EM></STRONG></P><P><STRONG><EM><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167205_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></EM></STRONG></P></BODY></HTML> Sun, 18 Jun 2017 07:28:34 GMT https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310105#M407365 Kushal_Chawda 2017-06-18T07:28:34Z Re: Count in Pivot table. https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310106#M407366 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see Attachment.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167204_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Regards,</P><P>Antonio</P></BODY></HTML> Sun, 18 Jun 2017 08:12:14 GMT https://community.qlik.com/t5/QlikView/Count-in-Pivot-table/m-p/1310106#M407366 antoniotiman 2017-06-18T08:12:14Z