Numbers

[Bhuvi]

Hello,

have to create set of increment numbers in Qlik

Data

Input	Output
1	1
2	1
3	1
4	1
5	1
6	2
7	2
8	2
9	2
10	2

[Or]

If this is all you need, just load these numbers in an inline load?

Otherwise, something like

Load Input, Floor(Input/5) as Output

From SomeTable;

[Bhuvi]

I have 100 lines of data so Inline cannot be done.

Floor(Input/5) gives 0 value also but in this case it should start from 1

[Or · Accepted solution]

Should have been Ceil(), not Floor(). But you could also just +1 the Floor() value.