topic Re: Create buckets using sequence number in QlikView https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591779#M596937 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6148">@rwunderlich</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28038">@marcus_sommer</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp; Any of your help is highly appreciated <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 13 Jun 2019 17:29:37 GMT markgraham123 2019-06-13T17:29:37Z Create buckets using sequence number https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591775#M596936 <P>Hi all,</P><P>Help please.</P><P>I'm trying to create 8 or 16 buckets in my dataset.&nbsp;</P><P>Looking at my sequence number, i should create buckets grouped by pair.</P><P>I can only be either 8 or 16 orders. If i cannot make up to 16 orders, i try to make 8 orders. Remaining go into bucket '99999'. If no 8 buckets can be made, all in that pair goes to '99999' Here is my sample data.&nbsp;</P><P>Please see attached for qvw. Please help!</P><P>Below is the data sample:</P><TABLE><TBODY><TR><TD>Order</TD><TD>SKU</TD><TD>Pair</TD><TD>Seq. Num</TD><TD>Bucket by Pair</TD></TR><TR><TD>121118463</TD><TD>100234</TD><TD>2</TD><TD>1</TD><TD>1</TD></TR><TR><TD>158856565</TD><TD>99358</TD><TD>2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>158856565</TD><TD>105266</TD><TD>2</TD><TD>2</TD><TD>1</TD></TR><TR><TD>159061651</TD><TD>67970</TD><TD>2</TD><TD>3</TD><TD>1</TD></TR><TR><TD>159061651</TD><TD>67972</TD><TD>2</TD><TD>3</TD><TD>1</TD></TR><TR><TD>159061651</TD><TD>86240</TD><TD>2</TD><TD>3</TD><TD>1</TD></TR><TR><TD>159080104</TD><TD>67972</TD><TD>2</TD><TD>4</TD><TD>1</TD></TR><TR><TD>159080104</TD><TD>99641</TD><TD>2</TD><TD>4</TD><TD>1</TD></TR><TR><TD>159080104</TD><TD>151281</TD><TD>2</TD><TD>4</TD><TD>1</TD></TR><TR><TD>159081551</TD><TD>93819</TD><TD>2</TD><TD>5</TD><TD>1</TD></TR><TR><TD>159097798</TD><TD>114205</TD><TD>2</TD><TD>6</TD><TD>1</TD></TR><TR><TD>159109358</TD><TD>76322</TD><TD>2</TD><TD>7</TD><TD>1</TD></TR><TR><TD>159109358</TD><TD>76324</TD><TD>2</TD><TD>7</TD><TD>1</TD></TR><TR><TD>159109358</TD><TD>76342</TD><TD>2</TD><TD>7</TD><TD>1</TD></TR><TR><TD>159129901</TD><TD>61810</TD><TD>2</TD><TD>8</TD><TD>1</TD></TR><TR><TD>159130517</TD><TD>76207</TD><TD>2</TD><TD>9</TD><TD>99999</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:40:11 GMT https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591775#M596936 markgraham123 2024-11-16T20:40:11Z Re: Create buckets using sequence number https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591779#M596937 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6148">@rwunderlich</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28038">@marcus_sommer</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp; Any of your help is highly appreciated <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 13 Jun 2019 17:29:37 GMT https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591779#M596937 markgraham123 2019-06-13T17:29:37Z Re: Create buckets using sequence number https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591782#M596938 <P>Just responded here</P><P><A href="https://community.qlik.com/t5/QlikView-Scripting/Create-a-sequence-number-and-create-buckets/m-p/1591738/highlight/false#M95613" target="_blank" rel="noopener">Create a sequence number and create buckets</A></P> Thu, 13 Jun 2019 17:40:32 GMT https://community.qlik.com/t5/QlikView/Create-buckets-using-sequence-number/m-p/1591782#M596938 sunny_talwar 2019-06-13T17:40:32Z