topic Re: Autonumbering to column in QlikView

Autonumbering to column

Mon, 03 Mar 2014 10:33:13 GMT

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

Mon, 03 Mar 2014 10:40:19 GMT

Sandeep,

You have the solution:

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

I do not see the point

Fabrice

aveeeeeee7en — Mon, 03 Mar 2014 10:44:40 GMT

Hi Sandeep

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

See the Attachment.

Regards

Aviral Nag