topic Re: Count Customer Code on X-axis in QlikView https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588550#M218239 <HTML><HEAD></HEAD><BODY><P>any idea?</P></BODY></HTML> Thu, 30 Jan 2014 10:23:18 GMT 2014-01-30T10:23:18Z Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588544#M218233 <HTML><HEAD></HEAD><BODY><P>how to use calculate dimension so as to have count of customer codes on x-axis.</P></BODY></HTML> Thu, 30 Jan 2014 09:30:16 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588544#M218233 2014-01-30T09:30:16Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588545#M218234 <HTML><HEAD></HEAD><BODY><P>Can you upload sample qvw.</P><P></P><P>Vikas</P></BODY></HTML> Thu, 30 Jan 2014 09:37:55 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588545#M218234 vikasmahajan 2014-01-30T09:37:55Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588546#M218235 <HTML><HEAD></HEAD><BODY><P>Can you attach some sample app</P></BODY></HTML> Thu, 30 Jan 2014 09:44:13 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588546#M218235 2014-01-30T09:44:13Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588547#M218236 <HTML><HEAD></HEAD><BODY><P>I will create one,&nbsp; and thanks for deleting that old sample .qvw..</P></BODY></HTML> Thu, 30 Jan 2014 09:46:08 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588547#M218236 2014-01-30T09:46:08Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588548#M218237 <HTML><HEAD></HEAD><BODY><P>Its Ok <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 30 Jan 2014 09:47:33 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588548#M218237 2014-01-30T09:47:33Z Re: Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588549#M218238 <HTML><HEAD></HEAD><BODY><P>please find the sample</P></BODY></HTML> Thu, 30 Jan 2014 10:11:49 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588549#M218238 2014-01-30T10:11:49Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588550#M218239 <HTML><HEAD></HEAD><BODY><P>any idea?</P></BODY></HTML> Thu, 30 Jan 2014 10:23:18 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588550#M218239 2014-01-30T10:23:18Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588551#M218240 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>See attached.</P><P>I added a chart grouping sales by 80% flag, dimension name giving the number of customers.</P><P>Hope it helps.</P></BODY></HTML> Thu, 30 Jan 2014 10:44:49 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588551#M218240 2014-01-30T10:44:49Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588552#M218241 <HTML><HEAD></HEAD><BODY><P>Dear Sir,</P><P></P><P>I need the graph in same manner as shown in the pic.</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 30 Jan 2014 10:56:47 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588552#M218241 2014-01-30T10:56:47Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588553#M218242 <HTML><HEAD></HEAD><BODY><P>any idea?</P></BODY></HTML> Fri, 31 Jan 2014 08:46:46 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588553#M218242 2014-01-31T08:46:46Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588554#M218243 <HTML><HEAD></HEAD><BODY><P>please advise guys</P></BODY></HTML> Fri, 31 Jan 2014 08:49:06 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588554#M218243 2014-01-31T08:49:06Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588555#M218244 <HTML><HEAD></HEAD><BODY><P>Please advise Guys..</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Sat, 01 Feb 2014 05:25:20 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588555#M218244 2014-02-01T05:25:20Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588556#M218245 <HTML><HEAD></HEAD><BODY><P>Help Guys</P></BODY></HTML> Sat, 01 Feb 2014 07:38:52 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588556#M218245 2014-02-01T07:38:52Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588557#M218246 <HTML><HEAD></HEAD><BODY><P>please advise</P></BODY></HTML> Sat, 01 Feb 2014 09:37:30 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588557#M218246 2014-02-01T09:37:30Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588558#M218247 <HTML><HEAD></HEAD><BODY><P>Count # Customers giiving 80% of Sale</P><P></P><P>=sum(aggr(if(RangeSum(Above(sum([Actual Sale])/Sum(TOTAL [Actual Sale]), 0, RowNo()))&lt;=0.8,1, 0), [Customer Code]))</P><P></P><P>michael</P></BODY></HTML> Sat, 01 Feb 2014 10:07:44 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588558#M218247 agilos_mla 2014-02-01T10:07:44Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588559#M218248 <HTML><HEAD></HEAD><BODY><P>it says"</P><P></P><P>Allocated Memory exceeded......:(</P></BODY></HTML> Sat, 01 Feb 2014 10:14:05 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588559#M218248 2014-02-01T10:14:05Z Re: Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588560#M218249 <HTML><HEAD></HEAD><BODY><P>Strange, you are 32 bits?</P><P></P><P>I attached you sample with the text box counter. </P><P>Try it !</P></BODY></HTML> Sat, 01 Feb 2014 10:17:56 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588560#M218249 agilos_mla 2014-02-01T10:17:56Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588561#M218250 <HTML><HEAD></HEAD><BODY><P>No we are 64 bits</P></BODY></HTML> Sat, 01 Feb 2014 10:19:45 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588561#M218250 2014-02-01T10:19:45Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588562#M218251 <HTML><HEAD></HEAD><BODY><P>when I am applying the command into dimension, it says "Allocated Memory exceeds"</P></BODY></HTML> Sat, 01 Feb 2014 10:21:48 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588562#M218251 2014-02-01T10:21:48Z Re: Count Customer Code on X-axis https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588563#M218252 <HTML><HEAD></HEAD><BODY><P>Sure, you cannot use an aggregation fucntion in the dimension.</P><P>Use the option text in chart&nbsp; (in Presentation tab) and add the formula within, then move the result where you want. with CTRL+Shift</P></BODY></HTML> Sat, 01 Feb 2014 10:27:44 GMT https://community.qlik.com/t5/QlikView/Count-Customer-Code-on-X-axis/m-p/588563#M218252 agilos_mla 2014-02-01T10:27:44Z