topic sum set analysis for certain field value in QlikView https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211930#M66057 <HTML><HEAD></HEAD><BODY><P></P><PRE class="jive_text_macro jive_macro_quote" jivemacro="quote"><BR />jasonseril wrote:<BR />sorry guys, i got the answer already...<BR />=<STRONG>Sum</STRONG>(<STRONG>IF</STRONG>(<STRONG>branch</STRONG> = 'H/Q',<STRONG>actual</STRONG>))<BR />Thanks.<BR />Jason<BR /><BR /><BR /><BR /><BR /><BR /><BR /> &lt;div&gt;&lt;/div&gt;<BR /></PRE><BR /><BR /> <P>as per your request to use set analysis then use:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />sum({&lt;branch={'H/Q'}&gt;} actual)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 09 Oct 2009 11:49:22 GMT 2009-10-09T11:49:22Z sum set analysis for certain field value https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211928#M66055 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P>I have a question on set analysis for finding the sum of "actual" value of all "H/Q" branch. Attached is the excel file of the data. Thanks in advance and have a good day.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-500_sourceID:500" /></P><P>regards,</P><P>Jason</P></BODY></HTML> Fri, 09 Oct 2009 09:44:10 GMT https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211928#M66055 jasonseril 2009-10-09T09:44:10Z sum set analysis for certain field value https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211929#M66056 <HTML><HEAD></HEAD><BODY><P>sorry guys, i got the answer already...</P><P>=<B>Sum</B>(<B>IF</B>(<B>branch</B> = 'H/Q',<B>actual</B>))</P><P>Thanks.</P><P>Jason</P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 09 Oct 2009 09:53:43 GMT https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211929#M66056 jasonseril 2009-10-09T09:53:43Z sum set analysis for certain field value https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211930#M66057 <HTML><HEAD></HEAD><BODY><P></P><PRE class="jive_text_macro jive_macro_quote" jivemacro="quote"><BR />jasonseril wrote:<BR />sorry guys, i got the answer already...<BR />=<STRONG>Sum</STRONG>(<STRONG>IF</STRONG>(<STRONG>branch</STRONG> = 'H/Q',<STRONG>actual</STRONG>))<BR />Thanks.<BR />Jason<BR /><BR /><BR /><BR /><BR /><BR /><BR /> &lt;div&gt;&lt;/div&gt;<BR /></PRE><BR /><BR /> <P>as per your request to use set analysis then use:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />sum({&lt;branch={'H/Q'}&gt;} actual)<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 09 Oct 2009 11:49:22 GMT https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211930#M66057 2009-10-09T11:49:22Z sum set analysis for certain field value https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211931#M66058 <HTML><HEAD></HEAD><BODY><P>Thank you very much, dragonauta.</P></BODY></HTML> Fri, 09 Oct 2009 15:20:48 GMT https://community.qlik.com/t5/QlikView/sum-set-analysis-for-certain-field-value/m-p/211931#M66058 jasonseril 2009-10-09T15:20:48Z