topic Total Count in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499170#M186516 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Please help me with this issue...</P><P></P><P>I have a pivot table with 2 dimensions and 2 expressions. (see pic.)</P><P></P><P><IMG __jive_id="43143" class="jive-image" alt="aa.png" src="https://community.qlik.com/legacyfs/online/43143_aa.png" /></P><P></P><P>I want that&nbsp; in the total column will show the total of the Name. as you can see in the pic that the expression is working only in one raw in the other one its write a '0' (circle by red square).</P><P></P><P>the Total expression is <SPAN style="color: #0000ff;">sum<SPAN style="font-size: 8pt;">(</SPAN></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Log</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Name</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P> the correct view should be like this:</P><P><IMG __jive_id="43144" class="jive-image" alt="aaa.png" src="https://community.qlik.com/legacyfs/online/43144_aaa.png" /></P><P></P><P>any idea?</P><P></P><P></P><P>Ariel</P></BODY></HTML> Sun, 23 Jun 2013 09:18:32 GMT ariel_klien 2013-06-23T09:18:32Z Total Count in Pivot Table https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499170#M186516 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Please help me with this issue...</P><P></P><P>I have a pivot table with 2 dimensions and 2 expressions. (see pic.)</P><P></P><P><IMG __jive_id="43143" class="jive-image" alt="aa.png" src="https://community.qlik.com/legacyfs/online/43143_aa.png" /></P><P></P><P>I want that&nbsp; in the total column will show the total of the Name. as you can see in the pic that the expression is working only in one raw in the other one its write a '0' (circle by red square).</P><P></P><P>the Total expression is <SPAN style="color: #0000ff;">sum<SPAN style="font-size: 8pt;">(</SPAN></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Log</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Name</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P> the correct view should be like this:</P><P><IMG __jive_id="43144" class="jive-image" alt="aaa.png" src="https://community.qlik.com/legacyfs/online/43144_aaa.png" /></P><P></P><P>any idea?</P><P></P><P></P><P>Ariel</P></BODY></HTML> Sun, 23 Jun 2013 09:18:32 GMT https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499170#M186516 ariel_klien 2013-06-23T09:18:32Z Re: Total Count in Pivot Table https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499171#M186517 <HTML><HEAD></HEAD><BODY><P>Try count(total &lt;Name&gt; Log)</P></BODY></HTML> Sun, 23 Jun 2013 10:49:06 GMT https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499171#M186517 Gysbert_Wassenaar 2013-06-23T10:49:06Z Re: Total Count in Pivot Table https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499172#M186518 <HTML><HEAD></HEAD><BODY><P>Working!!</P><P></P><P>Thanks</P></BODY></HTML> Sun, 23 Jun 2013 10:56:54 GMT https://community.qlik.com/t5/QlikView/Total-Count-in-Pivot-Table/m-p/499172#M186518 ariel_klien 2013-06-23T10:56:54Z