topic Aggr in pivot table in QlikView https://community.qlik.com/t5/QlikView/Aggr-in-pivot-table/m-p/790031#M279382 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I <SPAN style="font-size: 13.3333330154419px;">am facing one problem </SPAN> to create the pivot table . I am having two dimension and one expression</P><P>when i was creating the general count it is giving correctly and when i use the aggr() in the expression ,it is giving the value in different place (i.e when you write the aggr() the value of jan2013 in xais and jan2013 in y-axis&nbsp; it should be one value,but it not giving any value)</P><P>i am using the function <STRONG>aggr(count(clientid) startmonthyear) </STRONG></P><P><STRONG><BR /></STRONG>The pivot table should be like the sam.png file having the data.</P><P>I also attached sample qv file</P><P>can any one give me the solution&nbsp; </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></BODY></HTML> Wed, 25 Mar 2015 13:09:18 GMT kumarkp412 2015-03-25T13:09:18Z Aggr in pivot table https://community.qlik.com/t5/QlikView/Aggr-in-pivot-table/m-p/790031#M279382 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I <SPAN style="font-size: 13.3333330154419px;">am facing one problem </SPAN> to create the pivot table . I am having two dimension and one expression</P><P>when i was creating the general count it is giving correctly and when i use the aggr() in the expression ,it is giving the value in different place (i.e when you write the aggr() the value of jan2013 in xais and jan2013 in y-axis&nbsp; it should be one value,but it not giving any value)</P><P>i am using the function <STRONG>aggr(count(clientid) startmonthyear) </STRONG></P><P><STRONG><BR /></STRONG>The pivot table should be like the sam.png file having the data.</P><P>I also attached sample qv file</P><P>can any one give me the solution&nbsp; </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY></TBODY></TABLE></BODY></HTML> Wed, 25 Mar 2015 13:09:18 GMT https://community.qlik.com/t5/QlikView/Aggr-in-pivot-table/m-p/790031#M279382 kumarkp412 2015-03-25T13:09:18Z Re: Aggr in pivot table https://community.qlik.com/t5/QlikView/Aggr-in-pivot-table/m-p/790032#M279383 <HTML><HEAD></HEAD><BODY><P>See attached. If you don't need the totals consider turning them off - if you need them to load you can use the Dimensionality() function in an if statement..</P></BODY></HTML> Wed, 25 Mar 2015 15:00:55 GMT https://community.qlik.com/t5/QlikView/Aggr-in-pivot-table/m-p/790032#M279383 morganaaron 2015-03-25T15:00:55Z