topic How to make the bar display as 2 For reject code = 124 ? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920670#M653194 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I want to plot a chart that display the Qty of reject by reject code, I don't have the Qty value , i only have the reject code . May i know how to count number of reject code and display on the bar chart ?</P><P></P><P></P><P>Paul </P></BODY></HTML> Wed, 29 Jul 2015 15:28:22 GMT paulyeo11 2015-07-29T15:28:22Z How to make the bar display as 2 For reject code = 124 ? https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920670#M653194 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I want to plot a chart that display the Qty of reject by reject code, I don't have the Qty value , i only have the reject code . May i know how to count number of reject code and display on the bar chart ?</P><P></P><P></P><P>Paul </P></BODY></HTML> Wed, 29 Jul 2015 15:28:22 GMT https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920670#M653194 paulyeo11 2015-07-29T15:28:22Z Re: How to make the bar display as 2 For reject code = 124 ? https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920671#M653195 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P>try</P><P><SPAN style="color: #0000ff; font-size: 10pt;">count</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #0000ff;">Aggr</SPAN>(<SPAN style="color: #0000ff;">NODISTINCT</SPAN> <SPAN style="color: #800000;">kode_reject</SPAN>,<SPAN style="color: #800000;">line_id</SPAN></SPAN><SPAN style="font-size: 10pt;">)) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Wed, 29 Jul 2015 15:44:17 GMT https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920671#M653195 antoniotiman 2015-07-29T15:44:17Z Re: How to make the bar display as 2 For reject code = 124 ? https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920672#M653196 <HTML><HEAD></HEAD><BODY><P>Thank , it work fine.</P></BODY></HTML> Wed, 29 Jul 2015 15:57:50 GMT https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920672#M653196 paulyeo11 2015-07-29T15:57:50Z Re: How to make the bar display as 2 For reject code = 124 ? https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920673#M653197 <HTML><HEAD></HEAD><BODY><P>Hi Sir</P><P></P><P>I want to count total number of reject by kode_reject , meaning I will place kode_reject at dimension .</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Wed, 29 Jul 2015 16:33:16 GMT https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920673#M653197 paulyeo11 2015-07-29T16:33:16Z Re: How to make the bar display as 2 For reject code = 124 ? https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920674#M653198 <HTML><HEAD></HEAD><BODY><P>Try aggr() with date_time instead of line_id</P></BODY></HTML> Wed, 29 Jul 2015 17:14:19 GMT https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920674#M653198 antoniotiman 2015-07-29T17:14:19Z Re: How to make the bar display as 2 For reject code = 124 ? https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920675#M653199 <HTML><HEAD></HEAD><BODY><P>Hi Antonio</P><P></P><P>Thank you vey much , i manage to create all the chart i need.</P><P></P><P>Paul</P></BODY></HTML> Wed, 29 Jul 2015 23:24:53 GMT https://community.qlik.com/t5/QlikView/How-to-make-the-bar-display-as-2-For-reject-code-124/m-p/920675#M653199 paulyeo11 2015-07-29T23:24:53Z