Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps this?
$(Variable1) + RowNo()
Note - Here, Variable1 is input box. And the above expression should be expression?
Why not?
RowNo() + 100 as ID
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 .
Perhaps this?
$(Variable1) + RowNo()
Note - Here, Variable1 is input box. And the above expression should be expression?
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
Great
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 ...
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.
Thank you Thakur Ji .....