topic Add custom total in QlikView https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971148#M948056 <HTML><HEAD></HEAD><BODY><P>I have a filter comp </P><P></P><P><IMG alt="comp.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/109678_comp.png" style="height: auto;" /></P><P>How could I add a custom total below total with the same expression but with the condition of comp = O?</P><P><IMG alt="total.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109677_total.png" style="height: 182px; width: 620px;" /></P></BODY></HTML> Tue, 22 Dec 2015 10:21:53 GMT Anonymous 2015-12-22T10:21:53Z Add custom total https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971148#M948056 <HTML><HEAD></HEAD><BODY><P>I have a filter comp </P><P></P><P><IMG alt="comp.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/109678_comp.png" style="height: auto;" /></P><P>How could I add a custom total below total with the same expression but with the condition of comp = O?</P><P><IMG alt="total.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109677_total.png" style="height: 182px; width: 620px;" /></P></BODY></HTML> Tue, 22 Dec 2015 10:21:53 GMT https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971148#M948056 Anonymous 2015-12-22T10:21:53Z Re: Add custom total https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971149#M948057 <HTML><HEAD></HEAD><BODY><P>i thnk u can create a textobject and give the expression which vil give u the total on dat obj..</P><P></P><P>hope this helps u</P></BODY></HTML> Tue, 22 Dec 2015 10:25:22 GMT https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971149#M948057 Chanty4u 2015-12-22T10:25:22Z Re: Add custom total https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971150#M948058 <HTML><HEAD></HEAD><BODY><P>Use dimensionality() like:</P><P></P><P>If(dimensionality()=0, 'YourExpectedoutput' , Sum(sales))</P></BODY></HTML> Tue, 22 Dec 2015 10:29:09 GMT https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971150#M948058 tresB 2015-12-22T10:29:09Z Re: Add custom total https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971151#M948059 <HTML><HEAD></HEAD><BODY><P>Maybe you could look at adding a dummy Department?</P></BODY></HTML> Tue, 22 Dec 2015 10:29:11 GMT https://community.qlik.com/t5/QlikView/Add-custom-total/m-p/971151#M948059 roger_stone 2015-12-22T10:29:11Z