topic Re: How to hide subtotal value once a dimension is expanded in QlikView https://community.qlik.com/t5/QlikView/How-to-hide-subtotal-value-once-a-dimension-is-expanded/m-p/1211588#M388571 <HTML><HEAD></HEAD><BODY><P>See attached.</P></BODY></HTML> Sun, 23 Oct 2016 01:40:19 GMT posywang 2016-10-23T01:40:19Z How to hide subtotal value once a dimension is expanded https://community.qlik.com/t5/QlikView/How-to-hide-subtotal-value-once-a-dimension-is-expanded/m-p/1211587#M388570 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><SPAN style="color: #000000;">We got a user request to hide subtotal value once a dimension is expanded. They only want to see values of the lowest level that got expanded in a pivot table</SPAN>. </SPAN></P><P><SPAN style="color: #000000; font-family: arial,helvetica,sans-serif; font-size: 10pt;">Users don't want to see highlighted values show up in table multiple times to cause confusion that these values added up to the sum. How can blank these out while expanded but show value once collapsed? Thank you!</SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: arial,helvetica,sans-serif;">&nbsp; </SPAN></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: arial,helvetica,sans-serif;"><IMG __jive_id="141645" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/141645_pastedImage_6.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P></BODY></HTML> Sun, 23 Oct 2016 01:39:03 GMT https://community.qlik.com/t5/QlikView/How-to-hide-subtotal-value-once-a-dimension-is-expanded/m-p/1211587#M388570 posywang 2016-10-23T01:39:03Z Re: How to hide subtotal value once a dimension is expanded https://community.qlik.com/t5/QlikView/How-to-hide-subtotal-value-once-a-dimension-is-expanded/m-p/1211588#M388571 <HTML><HEAD></HEAD><BODY><P>See attached.</P></BODY></HTML> Sun, 23 Oct 2016 01:40:19 GMT https://community.qlik.com/t5/QlikView/How-to-hide-subtotal-value-once-a-dimension-is-expanded/m-p/1211588#M388571 posywang 2016-10-23T01:40:19Z