topic Re: Pivot - aggr in QlikView https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819396#M288887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried Properties&gt;&gt;Presentation&gt;&gt;&gt; Show Partial Sum</P></BODY></HTML> Wed, 12 Nov 2014 13:32:13 GMT jpenuliar 2014-11-12T13:32:13Z Pivot - aggr https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819395#M288886 <HTML><HEAD></HEAD><BODY><P><IMG alt="Udklip.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71081_Udklip.PNG.png" />Hi there</P><P></P><P>Is it possible to get the aggr( count), År) on every field where the expression match dimension ÅR. </P><P></P><P>ex every field with 2011 as dimension will contain 132...</P><P></P><P>Looking forward to hear your suggestions</P><P></P><P>Thanks</P><P>/Teis</P></BODY></HTML> Wed, 12 Nov 2014 13:29:34 GMT https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819395#M288886 2014-11-12T13:29:34Z Re: Pivot - aggr https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819396#M288887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried Properties&gt;&gt;Presentation&gt;&gt;&gt; Show Partial Sum</P></BODY></HTML> Wed, 12 Nov 2014 13:32:13 GMT https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819396#M288887 jpenuliar 2014-11-12T13:32:13Z Re: Pivot - aggr https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819397#M288888 <HTML><HEAD></HEAD><BODY><P>Use count(total &lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Å</SPAN>r&gt; Svar)</P></BODY></HTML> Wed, 12 Nov 2014 13:34:28 GMT https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819397#M288888 Gysbert_Wassenaar 2014-11-12T13:34:28Z Re: Pivot - aggr https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819398#M288889 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Show Partial Sum, will not get the job done, I need the total for dimension År in every field it match</P><P></P><P>thanks for the reply Jonathan</P></BODY></HTML> Wed, 12 Nov 2014 13:35:58 GMT https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819398#M288889 2014-11-12T13:35:58Z Re: Pivot - aggr https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819399#M288890 <HTML><HEAD></HEAD><BODY><P>Thanks&nbsp; a lot Gysbert</P><P></P><P>Do u know where I can find the definition on &lt;&gt; in a statement ?</P></BODY></HTML> Wed, 12 Nov 2014 13:37:49 GMT https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819399#M288890 2014-11-12T13:37:49Z Re: Pivot - aggr https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819400#M288891 <HTML><HEAD></HEAD><BODY><P>In the help file. Look up the Chart Aggregation Functions entry.</P></BODY></HTML> Wed, 12 Nov 2014 13:43:12 GMT https://community.qlik.com/t5/QlikView/Pivot-aggr/m-p/819400#M288891 Gysbert_Wassenaar 2014-11-12T13:43:12Z