topic Re: Total Sum only if one item selected in QlikView https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335787#M460213 <HTML><HEAD></HEAD><BODY><P>great!</P><P>thanks</P></BODY></HTML> Mon, 26 Jun 2017 17:34:49 GMT silvia_assuncao 2017-06-26T17:34:49Z Total Sum only if one item selected https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335784#M460210 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>I have this tab, and I want it to show the total sum only if I select one user (resource). is it possible?</P><P></P><P>thanks</P></BODY></HTML> Wed, 21 Jun 2017 18:11:42 GMT https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335784#M460210 silvia_assuncao 2017-06-21T18:11:42Z Re: Total Sum only if one item selected https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335785#M460211 <HTML><HEAD></HEAD><BODY><P>You can put:&nbsp; GetSelectedCount(Resource)=1 in the Conditional show of your chart. Then add a Resource listbox.</P></BODY></HTML> Wed, 21 Jun 2017 18:22:42 GMT https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335785#M460211 m_woolf 2017-06-21T18:22:42Z Re: Total Sum only if one item selected https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335786#M460212 <HTML><HEAD></HEAD><BODY><P>Check out this expression</P><P><STRONG>If(GetSelectedCount(Resource) &lt;&gt; 1, If(Dimensionality() &gt; 0, Sum([% Resource])), Sum([% Resource]))</STRONG></P></BODY></HTML> Wed, 21 Jun 2017 18:24:41 GMT https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335786#M460212 sunny_talwar 2017-06-21T18:24:41Z Re: Total Sum only if one item selected https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335787#M460213 <HTML><HEAD></HEAD><BODY><P>great!</P><P>thanks</P></BODY></HTML> Mon, 26 Jun 2017 17:34:49 GMT https://community.qlik.com/t5/QlikView/Total-Sum-only-if-one-item-selected/m-p/1335787#M460213 silvia_assuncao 2017-06-26T17:34:49Z