topic Issue with Total calculation on a pivot table in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Total-calculation-on-a-pivot-table/m-p/206036#M62304 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My data are :</P><P>load * Inline<BR />[Group,ID,Value<BR />A,ID1,12<BR />A,ID1,15<BR />A,ID2,10<BR />B,ID1,3<BR />B,ID3,14];</P><P>On a pivot table, I count distinct ID by Group</P><P>I would like to get a total IDs of 4 : 2 IDs per group, and QlikView gives a total of 3 because ID1 participates to group A and B.</P><P>How can I get the total I expect?</P><P>The example is attached</P><P>Thanks</P><P>Pierre.</P></BODY></HTML> Sat, 09 Jan 2010 23:04:14 GMT pdumas 2010-01-09T23:04:14Z Issue with Total calculation on a pivot table https://community.qlik.com/t5/QlikView/Issue-with-Total-calculation-on-a-pivot-table/m-p/206036#M62304 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>My data are :</P><P>load * Inline<BR />[Group,ID,Value<BR />A,ID1,12<BR />A,ID1,15<BR />A,ID2,10<BR />B,ID1,3<BR />B,ID3,14];</P><P>On a pivot table, I count distinct ID by Group</P><P>I would like to get a total IDs of 4 : 2 IDs per group, and QlikView gives a total of 3 because ID1 participates to group A and B.</P><P>How can I get the total I expect?</P><P>The example is attached</P><P>Thanks</P><P>Pierre.</P></BODY></HTML> Sat, 09 Jan 2010 23:04:14 GMT https://community.qlik.com/t5/QlikView/Issue-with-Total-calculation-on-a-pivot-table/m-p/206036#M62304 pdumas 2010-01-09T23:04:14Z Issue with Total calculation on a pivot table https://community.qlik.com/t5/QlikView/Issue-with-Total-calculation-on-a-pivot-table/m-p/206037#M62305 <HTML><HEAD></HEAD><BODY><P>Looks like you want it distinct by Group and ID together. See attached.</P><P>Tom</P></BODY></HTML> Sun, 10 Jan 2010 01:37:39 GMT https://community.qlik.com/t5/QlikView/Issue-with-Total-calculation-on-a-pivot-table/m-p/206037#M62305 2010-01-10T01:37:39Z