topic Trellis Chart Question in QlikView https://community.qlik.com/t5/QlikView/Trellis-Chart-Question/m-p/237566#M88619 <HTML><HEAD></HEAD><BODY><P>I found other related post with the same problem and no solution. So I think I have to set this up with separate bar charts.<BR />Can someone help me how the formula must look like to get top 10 error types per error. Thanks in advance.<BR /><BR />Tried with a dynamic dimension: =if(rank(aggr( sum( Amount ), Error ))=1, Type) for top 1 error and related types</P><P>but this is unfortunately not working</P><P><BR />Aloah</P></BODY></HTML> Mon, 02 May 2011 20:18:22 GMT 2011-05-02T20:18:22Z Trellis Chart Question https://community.qlik.com/t5/QlikView/Trellis-Chart-Question/m-p/237565#M88618 <HTML><HEAD></HEAD><BODY><P>Hello community,</P><P>I have errors (e.g. F1, F2) and error types( T1,T3 for error F1) (see attached qvw).</P><P>I'm trying to show the top X errortypes per error in a trellis chart.</P><P>Can someone tell me how to implement this (At the moment I get all types for each errror?</P><P><BR />Thanks in advance.<BR /><BR />Kind regards</P><P>Aloah</P><P></P></BODY></HTML> Mon, 02 May 2011 16:13:42 GMT https://community.qlik.com/t5/QlikView/Trellis-Chart-Question/m-p/237565#M88618 2011-05-02T16:13:42Z Trellis Chart Question https://community.qlik.com/t5/QlikView/Trellis-Chart-Question/m-p/237566#M88619 <HTML><HEAD></HEAD><BODY><P>I found other related post with the same problem and no solution. So I think I have to set this up with separate bar charts.<BR />Can someone help me how the formula must look like to get top 10 error types per error. Thanks in advance.<BR /><BR />Tried with a dynamic dimension: =if(rank(aggr( sum( Amount ), Error ))=1, Type) for top 1 error and related types</P><P>but this is unfortunately not working</P><P><BR />Aloah</P></BODY></HTML> Mon, 02 May 2011 20:18:22 GMT https://community.qlik.com/t5/QlikView/Trellis-Chart-Question/m-p/237566#M88619 2011-05-02T20:18:22Z