Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
markgraham123
Valued Contributor

Create buckets using sequence number

Hi all,

Help please.

I'm trying to create 8 or 16 buckets in my dataset. 

Looking at my sequence number, i should create buckets grouped by pair.

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. 

Please see attached for qvw. Please help!

Below is the data sample:

OrderSKUPairSeq. NumBucket by Pair
121118463100234211
15885656599358221
158856565105266221
15906165167970231
15906165167972231
15906165186240231
15908010467972241
15908010499641241
159080104151281241
15908155193819251
159097798114205261
15910935876322271
15910935876324271
15910935876342271
15912990161810281
159130517762072999999
1 Solution

Accepted Solutions

Re: Create buckets using sequence number

2 Replies
markgraham123
Valued Contributor

Re: Create buckets using sequence number

@rwunderlich @marcus_sommer @sunny_talwar  Any of your help is highly appreciated 🙂

Re: Create buckets using sequence number