topic selected values in Archived Groups https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661650#M2722 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 279px; height: 208px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">BRANCH</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>BRANCH&nbsp; profit</P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>BRANCH PROFIT SUM</P></TH></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B2</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">B4</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">B5</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">400</TD></TR><TR><TD style="padding: 2px;">B6</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B7</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I need this data in poivt or stright table only which branch have "N" in BRANCH profit</P><P>DIM : BRANCH</P><P>EXP : ...................</P></BODY></HTML> Tue, 22 Jul 2025 17:59:49 GMT sakamsureshbabu 2025-07-22T17:59:49Z selected values https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661650#M2722 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="224" style="border: 1px solid rgb(0, 0, 0); width: 279px; height: 208px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">BRANCH</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>BRANCH&nbsp; profit</P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P>BRANCH PROFIT SUM</P></TH></TR><TR><TD style="padding: 2px;">B1</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B2</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">B3</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">300</TD></TR><TR><TD style="padding: 2px;">B4</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">500</TD></TR><TR><TD style="padding: 2px;">B5</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">400</TD></TR><TR><TD style="padding: 2px;">B6</TD><TD style="padding: 2px;">N</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B7</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>I need this data in poivt or stright table only which branch have "N" in BRANCH profit</P><P>DIM : BRANCH</P><P>EXP : ...................</P></BODY></HTML> Tue, 22 Jul 2025 17:59:49 GMT https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661650#M2722 sakamsureshbabu 2025-07-22T17:59:49Z Re: selected values https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661651#M2723 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>Take a look on the attached file.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Mon, 20 Oct 2014 12:43:06 GMT https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661651#M2723 Anonymous 2014-10-20T12:43:06Z Re: selected values https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661652#M2724 <HTML><HEAD></HEAD><BODY><P>plz send <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">attached file</SPAN></P></BODY></HTML> Mon, 20 Oct 2014 12:49:19 GMT https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661652#M2724 sakamsureshbabu 2014-10-20T12:49:19Z Re: Re: selected values https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661653#M2725 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>The file is attached in my previous post.</P><P>Maybe some error happened, so I'm sending again here.</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Mon, 20 Oct 2014 12:55:13 GMT https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661653#M2725 Anonymous 2014-10-20T12:55:13Z Re: selected values https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661654#M2726 <HTML><HEAD></HEAD><BODY><P>adapt to your field (case sensitive)</P><P>sum({&lt;[BRANCH profit]={N}&gt;} [BRANCH PROFIT sum])</P></BODY></HTML> Mon, 20 Oct 2014 13:27:51 GMT https://community.qlik.com/t5/Archived-Groups/selected-values/m-p/661654#M2726 maxgro 2014-10-20T13:27:51Z