topic Report creation in QlikView https://community.qlik.com/t5/QlikView/Report-creation/m-p/476396#M480847 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a report looping over tertials (grouping of 4 and 4 month). I have done that, so far so good. Then the problem emerges, there are too many values of "Clubs" in one chart. Is there a way I can limit the clubs to 3 or 4 for each chart? Meaning that I want to have two charts instead of one.</P><P></P><P>I am aware that I can create two different charts with the Club-={clubname} and in that way limit the clubs for each chart. But this is not a dynamic way of doing it. Can I have a function sorting alphabetically including the first 4 clubs, and then the next 3 in a new&nbsp; chart? </P><P></P><P>Thanks</P><P> </P><P></P><P></P><P> </P><P></P><P><BR /> </P></BODY></HTML> Mon, 04 Nov 2013 08:49:46 GMT 2013-11-04T08:49:46Z Report creation https://community.qlik.com/t5/QlikView/Report-creation/m-p/476396#M480847 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to create a report looping over tertials (grouping of 4 and 4 month). I have done that, so far so good. Then the problem emerges, there are too many values of "Clubs" in one chart. Is there a way I can limit the clubs to 3 or 4 for each chart? Meaning that I want to have two charts instead of one.</P><P></P><P>I am aware that I can create two different charts with the Club-={clubname} and in that way limit the clubs for each chart. But this is not a dynamic way of doing it. Can I have a function sorting alphabetically including the first 4 clubs, and then the next 3 in a new&nbsp; chart? </P><P></P><P>Thanks</P><P> </P><P></P><P></P><P> </P><P></P><P><BR /> </P></BODY></HTML> Mon, 04 Nov 2013 08:49:46 GMT https://community.qlik.com/t5/QlikView/Report-creation/m-p/476396#M480847 2013-11-04T08:49:46Z Re: Report creation https://community.qlik.com/t5/QlikView/Report-creation/m-p/476397#M480848 <HTML><HEAD></HEAD><BODY><P>Ideally I want to limit the dimension based on alphabetically order, showing the first 5 values.</P></BODY></HTML> Mon, 04 Nov 2013 09:19:45 GMT https://community.qlik.com/t5/QlikView/Report-creation/m-p/476397#M480848 2013-11-04T09:19:45Z