Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Autonumbering to column

Hi guys,

I have a very urgent query...

1) I have to select a range of string values from column x (ex: A1100, AD1111, F990, X600) using input box.....

     Now i have to choose first two values from list box x (A1100,AD1111) by putting values in input box....

2) to do this i have to assign numbers to the column ie listbox x ie

                        x       Number 

                     A1100    1

                     AD111    2

                     F9900     3

                     x6000     4

3) Now i have to create a new column automatically in script.

Help me asap to get this query...

Thanks and regards

sandeep

2 Replies
Not applicable
Author

Sandeep,

You have the solution:

LOAD ... AutoNumber(x) as Number ....

I do not see the point

Fabrice

aveeeeeee7en
Specialist III
Specialist III

Hi Sandeep

You can assign Autonumber by using Rowno() either in Script or in Expression.

See the Attachment.

Regards

Aviral Nag