topic Sum/Total excluding certain items in QlikView https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168535#M39648 <HTML><HEAD></HEAD><BODY><P>hi</P><P>as there is aproblem in the site and i cant attach a file,</P><P>you can cotrol the sub totals by using dimensionality</P><P>this is a link to a file with example</P><P><A href="https://download.yousendit.com/VGljZUNpTk1ENlEwTVE9PQ">https://download.yousendit.com/VGljZUNpTk1ENlEwTVE9PQ</A></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold"></P><B></B><P style="font-weight: bold"></P><P></P>hope it will help you<BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 04 Mar 2010 15:13:16 GMT lironbaram 2010-03-04T15:13:16Z Sum/Total excluding certain items https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168534#M39647 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>I'm looking for a way to exclude certain rows from the total of pivot table:</P><P>Let's assume I had a table like that</P><P>PRODUCT<BR />A 10<BR />B 20<BR />C 50<BR />TOTAL 80</P><P>And I would like to display the table like it is but exclude B from the total, so that the total shows as 60 while all the details for A, B and C show.<BR />Not displaying B is not an option, also because I have three fact dimensions and a time dimension I cannot switch to a straight table.</P><P>Thanks for your help!</P><P>Cheers, Lukas</P></BODY></HTML> Thu, 04 Mar 2010 14:08:36 GMT https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168534#M39647 2010-03-04T14:08:36Z Sum/Total excluding certain items https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168535#M39648 <HTML><HEAD></HEAD><BODY><P>hi</P><P>as there is aproblem in the site and i cant attach a file,</P><P>you can cotrol the sub totals by using dimensionality</P><P>this is a link to a file with example</P><P><A href="https://download.yousendit.com/VGljZUNpTk1ENlEwTVE9PQ">https://download.yousendit.com/VGljZUNpTk1ENlEwTVE9PQ</A></P><P></P><P style="font-weight: bold"></P><P style="font-weight: bold"></P><B></B><P style="font-weight: bold"></P><P></P>hope it will help you<BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 04 Mar 2010 15:13:16 GMT https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168535#M39648 lironbaram 2010-03-04T15:13:16Z Sum/Total excluding certain items https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168536#M39649 <HTML><HEAD></HEAD><BODY><P>Thanks, you've saved my day, it works perfectly well!</P><P>Have a nice day</P><P>Lukas</P></BODY></HTML> Thu, 04 Mar 2010 15:28:07 GMT https://community.qlik.com/t5/QlikView/Sum-Total-excluding-certain-items/m-p/168536#M39649 2010-03-04T15:28:07Z