topic Re: Tickets (with diff. reasons) for products in QlikView https://community.qlik.com/t5/QlikView/Tickets-with-diff-reasons-for-products/m-p/951819#M979993 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this exression,</P><P>Sum( aggr(if( rank(Count(Reason), Product, <SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>)&lt;=3,Count(<SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>)), Product, <SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>)) / Sum(Total&lt;Product&gt;&nbsp; aggr( Count(<SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>), Product, <SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>))</P></BODY></HTML> Wed, 19 Aug 2015 10:06:00 GMT 2015-08-19T10:06:00Z Tickets (with diff. reasons) for products https://community.qlik.com/t5/QlikView/Tickets-with-diff-reasons-for-products/m-p/951818#M979992 <HTML><HEAD></HEAD><BODY><P>hey everybody,</P><P></P><P>i've more or less 30 different products. Customers are allowed to write tickets for each product whenever Problems emerge.</P><P></P><P>These tickets consist out of different reasons.</P><P>I want to show that for example product A caused 1000 tickets, wheareas&nbsp; the table should Display whole tickets for the product and number of tickets for the 3 most important reasons (in % relation to the whole thickets of the product!</P><P></P><P>May you have any ideas?!</P><P></P><P> It should look somehow like the table below, but there should be a column for the 1. , 2. and 3. largest reason! and the % should be calculated&nbsp; by each product instead over all products!</P><P><IMG __jive_id="96318" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/96408_pastedImage_0.png" /></P></BODY></HTML> Wed, 19 Aug 2015 08:37:13 GMT https://community.qlik.com/t5/QlikView/Tickets-with-diff-reasons-for-products/m-p/951818#M979992 Anonymous 2015-08-19T08:37:13Z Re: Tickets (with diff. reasons) for products https://community.qlik.com/t5/QlikView/Tickets-with-diff-reasons-for-products/m-p/951819#M979993 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this exression,</P><P>Sum( aggr(if( rank(Count(Reason), Product, <SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>)&lt;=3,Count(<SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>)), Product, <SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>)) / Sum(Total&lt;Product&gt;&nbsp; aggr( Count(<SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>), Product, <SPAN style="font-size: 13.3333330154419px;">Reason</SPAN>))</P></BODY></HTML> Wed, 19 Aug 2015 10:06:00 GMT https://community.qlik.com/t5/QlikView/Tickets-with-diff-reasons-for-products/m-p/951819#M979993 2015-08-19T10:06:00Z