topic Individual total by Branch in QlikView https://community.qlik.com/t5/QlikView/Individual-total-by-Branch/m-p/600362#M222197 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>Please see attached Excel and qvw&nbsp; files.</P><P></P><P>In qvw file I want Branch1 and Branch2 total according to there individual.</P><P></P><P>I am doing something wrong that's why it repeated.</P><P></P><P>Please can you help me guys.</P><P></P><P>Thanks</P><P>Vinay</P></BODY></HTML> Tue, 06 May 2014 11:29:49 GMT 2014-05-06T11:29:49Z Individual total by Branch https://community.qlik.com/t5/QlikView/Individual-total-by-Branch/m-p/600362#M222197 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>Please see attached Excel and qvw&nbsp; files.</P><P></P><P>In qvw file I want Branch1 and Branch2 total according to there individual.</P><P></P><P>I am doing something wrong that's why it repeated.</P><P></P><P>Please can you help me guys.</P><P></P><P>Thanks</P><P>Vinay</P></BODY></HTML> Tue, 06 May 2014 11:29:49 GMT https://community.qlik.com/t5/QlikView/Individual-total-by-Branch/m-p/600362#M222197 2014-05-06T11:29:49Z Re: Individual total by Branch https://community.qlik.com/t5/QlikView/Individual-total-by-Branch/m-p/600363#M222198 <HTML><HEAD></HEAD><BODY><P>It's done by myself</P><P><SPAN style="color: #008000; font-size: 8pt;">I was using...</SPAN></P><P>=aggr(sum({&lt;Branch = P(Branch1) &gt;}sales),Group,Branch1,[Branch Name1]) </P><P></P><P>But now I used</P><P></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Branch</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #800000; font-size: 8pt;">Branch1</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">sales</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P><SPAN style="font-size: 8pt;">and its working.</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Any way thanks for watching forum.</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Vinay</SPAN></P><P></P><P></P><P></P><P><BR /> </P></BODY></HTML> Tue, 06 May 2014 11:57:58 GMT https://community.qlik.com/t5/QlikView/Individual-total-by-Branch/m-p/600363#M222198 2014-05-06T11:57:58Z