How to force qlikview to start numbering of rows from user defined number ?

[shekhar_analyti]

Hi All ,

How to force qlikview to start numbering of rows from user defined number ?

Example - Let Say we have 10 records In load script  .

Area	Zone	Date	Sale
A1	Z1	12/12/2017	100
A2	Z3	12/13/2017	300
A3	Z1	12/14/2017	100
A4	Z2	12/15/2017	200
A5	Z2	12/16/2017	200
A6	Z1	12/17/2017	100
A7	Z3	12/18/2017	300
A8	Z1	12/19/2017	100
A9	Z2	12/20/2017	200
A10	Z2	12/21/2017	200

RowNo() as Row will create a field Row with value staring from 1 and last as 10

My requirement is to start Row value from 100 and last as 110

Thanks & Regards

Shekar

[Anil_Babu_Samineni]

Why not?

RowNo() + 100 as ID

[shekhar_analyti]

Hi Anil ,

What you have mentioned is hard coding 100 .. But i want an input box to enter that user defined number and once user enter number in input box then it should act .

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

$(Variable1) + RowNo()

Note - Here, Variable1 is input box. And the above expression should be expression?

[shekhar_analyti]

i was using same $(vTest)+ RowNo() in expression of straight table  and passing 100 in vTest using ip box , then all values are coming as 101

[Anil_Babu_Samineni]

Great

[shekhar_analyti]

i got it actually i was doing one silly mistake ..Gosssssh  i had added rowno() in dimesion as well which was hidden it seems ...
thank you Anil ...

[pradosh_thakur]

Hi Shekhar

if you are using more than one dimension you have to use rowno(total) instead of rowno(). May be that was the issue.

Anyways you got the answer so all well and good.

[shekhar_analyti]

Thank you Thakur Ji .....