topic Re: Splitting a field by values into axes? in QlikView https://community.qlik.com/t5/QlikView/Splitting-a-field-by-values-into-axes/m-p/437480#M163134 <HTML><HEAD></HEAD><BODY><P>Seems like I'm not the only one stumped?&nbsp; That makes me feel a little better.&nbsp; <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 15 Apr 2013 21:12:24 GMT 2013-04-15T21:12:24Z Splitting a field by values into axes? https://community.qlik.com/t5/QlikView/Splitting-a-field-by-values-into-axes/m-p/437479#M163133 <HTML><HEAD></HEAD><BODY><P>In the database I'm working with, I'm trying to create charts by incident or request, with category on one axis, and subcategory on another.&nbsp;&nbsp; The problem is, for some reason, there is a custom field table, where, for example, incident category =5, incident subcategory = 6, request category = 7, request category = 8.&nbsp; </P><P></P><P>I can create a chart with incident category on one axis and incident subcategory on another, but when I try to count them by ticket number, I get a chart with one labeled item on each axis, and one unlabeled item on each axis.&nbsp; Each ticket is getting counted twice, once for category, and once for subcategory.&nbsp; If I suppress null value on one, no data shows, because each ticket has two values associated with it, category and subcategory.</P><P></P><P>Any ideas on how I can get this to work?</P><P></P><P>I have attached a screenshot of my resulting chart with just 3 tickets selected.</P></BODY></HTML> Tue, 09 Apr 2013 17:04:19 GMT https://community.qlik.com/t5/QlikView/Splitting-a-field-by-values-into-axes/m-p/437479#M163133 2013-04-09T17:04:19Z Re: Splitting a field by values into axes? https://community.qlik.com/t5/QlikView/Splitting-a-field-by-values-into-axes/m-p/437480#M163134 <HTML><HEAD></HEAD><BODY><P>Seems like I'm not the only one stumped?&nbsp; That makes me feel a little better.&nbsp; <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 15 Apr 2013 21:12:24 GMT https://community.qlik.com/t5/QlikView/Splitting-a-field-by-values-into-axes/m-p/437480#M163134 2013-04-15T21:12:24Z