topic Re: How To Create Custom Bucketing in QlikView https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266813#M100223 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>maybe u can try "class" function to aggregate....</P><P>or u can use "aggr" function to create calculated dimension</P><P></P><P>C u,</P><P>Stefano</P></BODY></HTML> Thu, 15 Sep 2011 22:14:41 GMT 2011-09-15T22:14:41Z How To Create Custom Bucketing https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266812#M100222 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana,geneva; color: #000080;">Hello,</SPAN></P><P><SPAN style="font-family: verdana,geneva; color: #000080;">I have this report that has too many buckets 1 to 30 buckets (see attached image).&nbsp; </SPAN></P><P><SPAN style="font-family: verdana,geneva; color: #000080;">Is there a way to customize it in my chart?&nbsp; </SPAN></P><P><SPAN style="font-family: verdana,geneva; color: #000080;">For example, bucket 1-5 as FirstVisit, bucket 5-10 as SecondVisit, bucket 10+ as RepeatVisit.</SPAN></P><P><SPAN style="font-family: verdana,geneva; color: #000080;">Each custom bucket can show either Total or % of Total.</SPAN></P><P><SPAN style="font-family: verdana,geneva; color: #000080;">BTW, the dimension is called RepeatBucket.&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: verdana,geneva; color: #000080;">Any help is appreciated!</SPAN></P></BODY></HTML> Thu, 15 Sep 2011 22:03:25 GMT https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266812#M100222 2011-09-15T22:03:25Z Re: How To Create Custom Bucketing https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266813#M100223 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>maybe u can try "class" function to aggregate....</P><P>or u can use "aggr" function to create calculated dimension</P><P></P><P>C u,</P><P>Stefano</P></BODY></HTML> Thu, 15 Sep 2011 22:14:41 GMT https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266813#M100223 2011-09-15T22:14:41Z Re: How To Create Custom Bucketing https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266814#M100224 <HTML><HEAD></HEAD><BODY><P>Did you find the solution for your question.</P></BODY></HTML> Sat, 11 May 2013 01:26:11 GMT https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266814#M100224 2013-05-11T01:26:11Z Re: How To Create Custom Bucketing https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266815#M100225 <HTML><HEAD></HEAD><BODY><P>You may try the following:</P><P></P><P>If(bucket &lt;= 5,'FirstVisit', If(bucket &lt;= 10,'SecondVisit','RepeatVisit')) as RepeatBucket</P></BODY></HTML> Sat, 11 May 2013 01:32:55 GMT https://community.qlik.com/t5/QlikView/How-To-Create-Custom-Bucketing/m-p/266815#M100225 nagaiank 2013-05-11T01:32:55Z