topic sum by categories in QlikView https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582086#M679529 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I have 2 fileds</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">categ</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">amount</TH></TR><TR><TD style="padding: 2px;">A - categ1</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">A - categ2</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">A - categ1</TD><TD style="padding: 2px;">123</TD></TR><TR><TD style="padding: 2px;">A - categ3</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">B - categ33</TD><TD style="padding: 2px;">61</TD></TR><TR><TD style="padding: 2px;">B - categ44</TD><TD style="padding: 2px;">88</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>i need to make totals</P><P>- on transactions where categ starts with "A-"</P><P>- on transactions where categ starts with "B-"</P><P></P><P>thanks in advance</P></BODY></HTML> Tue, 15 Apr 2014 20:03:02 GMT Anonymous 2014-04-15T20:03:02Z sum by categories https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582086#M679529 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I have 2 fileds</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">categ</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">amount</TH></TR><TR><TD style="padding: 2px;">A - categ1</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">A - categ2</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">A - categ1</TD><TD style="padding: 2px;">123</TD></TR><TR><TD style="padding: 2px;">A - categ3</TD><TD style="padding: 2px;">55</TD></TR><TR><TD style="padding: 2px;">B - categ33</TD><TD style="padding: 2px;">61</TD></TR><TR><TD style="padding: 2px;">B - categ44</TD><TD style="padding: 2px;">88</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P>i need to make totals</P><P>- on transactions where categ starts with "A-"</P><P>- on transactions where categ starts with "B-"</P><P></P><P>thanks in advance</P></BODY></HTML> Tue, 15 Apr 2014 20:03:02 GMT https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582086#M679529 Anonymous 2014-04-15T20:03:02Z Re: sum by categories https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582087#M679530 <HTML><HEAD></HEAD><BODY><P>Possible Solution?</P><P>=left(categ,1) as a calculated dimension in the Dimension tab of a straight table or chart?</P><P>See the attachment (built with 11.20 sr5)</P><P></P><P>Hope this Helps.</P><P>Greg</P></BODY></HTML> Tue, 15 Apr 2014 20:13:58 GMT https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582087#M679530 Greg_Williams 2014-04-15T20:13:58Z Re: sum by categories https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582088#M679531 <HTML><HEAD></HEAD><BODY><P>Thank you Greg!</P><P>It made the work ...</P></BODY></HTML> Wed, 16 Apr 2014 09:43:45 GMT https://community.qlik.com/t5/QlikView/sum-by-categories/m-p/582088#M679531 Anonymous 2014-04-16T09:43:45Z