topic Subtotal in QlikView https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245682#M395075 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table with sales by month and I want to show the subtotal about it. The issue is, I want to show the subtotal, only if more than 1 month be selected, do you guys know if it is possible?</P><P></P><P>Sincerely, Luiz Bisco</P></BODY></HTML> Tue, 07 Mar 2017 16:44:10 GMT 2017-03-07T16:44:10Z Subtotal https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245682#M395075 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table with sales by month and I want to show the subtotal about it. The issue is, I want to show the subtotal, only if more than 1 month be selected, do you guys know if it is possible?</P><P></P><P>Sincerely, Luiz Bisco</P></BODY></HTML> Tue, 07 Mar 2017 16:44:10 GMT https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245682#M395075 2017-03-07T16:44:10Z Re: Subtotal https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245683#M395076 <HTML><HEAD></HEAD><BODY><P>Hi Luiz,</P><P>Short time ago we had the same problem and we had to solve it using 2 distinct objtecs: one with subtotals and other without them. They show or hide based on the number of selected values in a field.</P><P>Hope you find another way.</P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 07 Mar 2017 16:54:28 GMT https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245683#M395076 hector_munoz 2017-03-07T16:54:28Z Re: Subtotal https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245684#M395077 <HTML><HEAD></HEAD><BODY><P>Thank you, it works! </P></BODY></HTML> Tue, 07 Mar 2017 17:32:48 GMT https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245684#M395077 2017-03-07T17:32:48Z Re: Subtotal https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245685#M395078 <HTML><HEAD></HEAD><BODY><P>May be something like this in one object</P><P></P><P><STRONG>If(GetSelectedCount(Month) &gt; 1, Sum(Sales), Aggr(Sum(Sales), Month))</STRONG></P><P></P><P>The above will only show a total when more than one Month is selected in the Month field</P></BODY></HTML> Tue, 07 Mar 2017 17:40:31 GMT https://community.qlik.com/t5/QlikView/Subtotal/m-p/1245685#M395078 sunny_talwar 2017-03-07T17:40:31Z