topic Chart help in QlikView https://community.qlik.com/t5/QlikView/Chart-help/m-p/232168#M504708 <HTML><HEAD></HEAD><BODY><P>Sander,</P><P>sure, this is what Advanced Aggregation is for:</P><P>1. Create a calculated dimension:</P><P>=aggr(count(Repair), Serial)</P><P>2. Create an expression:</P><P>count(distinct Serial)</P><P>3. Pretty up and enjoy!</P><P></P></BODY></HTML> Thu, 05 Nov 2009 01:45:27 GMT Oleg_Troyansky 2009-11-05T01:45:27Z Chart help https://community.qlik.com/t5/QlikView/Chart-help/m-p/232167#M504705 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have got the following question. I want to create a chart with the number of unique SERIALS on the y-axis and how many times they are repaired on the x-axis.</P><P>The source data looks like this:</P><TABLE border="1" width="150"><TBODY><TR><TD>REPAIR</TD><TD>SERIAL</TD></TR><TR><TD>R0001</TD><TD>12345</TD></TR><TR><TD>R0002</TD><TD>12366</TD></TR><TR><TD>R0003</TD><TD>12367</TD></TR><TR><TD>R0004</TD><TD>12345</TD></TR><TR><TD>R0005</TD><TD>12368</TD></TR><TR><TD>R0006</TD><TD>12345</TD></TR><TR><TD>R0007</TD><TD>12367</TD></TR><TR><TD>R0008</TD><TD>12369</TD></TR><TR><TD>R0009</TD><TD>12370</TD></TR></TBODY></TABLE><P>The chart should look something like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-579_sourceID:579" /></P><P>So it displays the number of unique serials and how many times they are repaired within the selection.</P><P>Hope you guys can help!</P><P>Regards, Sander</P><P></P></BODY></HTML> Thu, 05 Nov 2009 01:34:44 GMT https://community.qlik.com/t5/QlikView/Chart-help/m-p/232167#M504705 2009-11-05T01:34:44Z Chart help https://community.qlik.com/t5/QlikView/Chart-help/m-p/232168#M504708 <HTML><HEAD></HEAD><BODY><P>Sander,</P><P>sure, this is what Advanced Aggregation is for:</P><P>1. Create a calculated dimension:</P><P>=aggr(count(Repair), Serial)</P><P>2. Create an expression:</P><P>count(distinct Serial)</P><P>3. Pretty up and enjoy!</P><P></P></BODY></HTML> Thu, 05 Nov 2009 01:45:27 GMT https://community.qlik.com/t5/QlikView/Chart-help/m-p/232168#M504708 Oleg_Troyansky 2009-11-05T01:45:27Z Chart help https://community.qlik.com/t5/QlikView/Chart-help/m-p/232169#M504710 <HTML><HEAD></HEAD><BODY><P>Advanced aggregation.... Off course...</P><P>Thanks, Oleg! You're the man!</P></BODY></HTML> Thu, 05 Nov 2009 01:56:06 GMT https://community.qlik.com/t5/QlikView/Chart-help/m-p/232169#M504710 2009-11-05T01:56:06Z