Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chiru_thota
Specialist
Specialist

Want to create one more column to group the sequence no as buckets

Hi all,

I have data as below

Date,   SequenceNO

04/30/2014,   1

04/29/2014 ,   2

04/28/2014,    3

04/27/2014,    4

............... so on

Now I want to create one more column Bucket to group my Sequence No's.

SequenceNoBucket
1-301
30-602
60-903

Date,   SequenceNO ,Bucket

04/30/2014,   1  ,1

04/29/2014 ,   2 ,1

04/28/2014,    3 ,1

04/27/2014,    4 , 1

............... so on

03/01/2014,31,2

03/02/2014,1,2

thanks in Advance,

Chiru

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Try

IF(MOD(SequenceNO,30)<>0,DIV(SequenceNO,30)+1,DIV(SequenceNO,30)) as Bucket

View solution in original post

4 Replies
anbu1984
Master III
Master III

If(Floor(SequenceNO/30) = 0, 1,Floor(SequenceNO/30)) As Bucket

MK_QSL
MVP
MVP

Try

IF(MOD(SequenceNO,30)<>0,DIV(SequenceNO,30)+1,DIV(SequenceNO,30)) as Bucket

MK_QSL
MVP
MVP

Only helpful ? anything missing ?

chiru_thota
Specialist
Specialist
Author

Thanks Both of you!

You guys rock!