topic Adding a Sequential numbers Column in QlikView

Adding a Sequential numbers Column

Wed, 21 Jul 2010 00:04:37 GMT

Hi all,

I have a simple excel sheet loaded by the following code:

load
Name, Address
from [.\Names.xls]
(biff, embedded labels, table is Sheet1$);

I'd like to add a column which is an auto generated sequential number.

Table in Excel:
Name Address
Simon City1
Peter City2
Farah City3

Required Table in QlikView:
RrdID Name Address
1 Simon City1
2 Peter City2
3 Farah City3

Adding a Sequential numbers Column

Wed, 21 Jul 2010 00:43:03 GMT

Apologies for being cheeky, but why not add this number in Excel?

Adding a Sequential numbers Column

Wed, 21 Jul 2010 01:13:54 GMT

Because actually data sources are from multiple files joined into one table in Qlikview. I just wanted to make my question simple and clear.

Adding a Sequential numbers Column

disqr_rm — Wed, 21 Jul 2010 02:02:16 GMT

Use RowNo() function in your chart expression and drag it to make it first column in your chart (if it has to be first column).

If you have subtotals in your chart, you may have to use RowNo(Total). Just play with it and you would know.

Hope this helps.

Adding a Sequential numbers Column

Wed, 21 Jul 2010 02:13:06 GMT

Thanks Rakesh for your answer.

But actually, I want the numbers in the table-level, if possible.

Adding a Sequential numbers Column

disqr_rm — Wed, 21 Jul 2010 02:45:21 GMT

oh! I misunderstood. Try this:

load

RecNo() as RecordNumber, Name, Address

from [.\Names.xls]

(biff, embedded labels, table is Sheet1$);

Adding a Sequential numbers Column

Wed, 21 Jul 2010 06:47:40 GMT

Unluckily it didn't work.

Following is what I tried and got:

Code:
T2:
LOAD RecNo() RID,
CUST_ID as CUST_ID,
CUST_NAME as CUST_NAME2
FROM

(biff, embedded labels, table is CUSTS2$);

Error Returned:
Syntax error, missing/misplaced FROM:
T2:
LOAD RecNo() RID,
CUST_ID as CUST_ID,
CUST_NAME as CUST_NAME2
FROM

(biff, embedded labels, table is CUSTS2$)

Adding a Sequential numbers Column

llauses243 — Wed, 21 Jul 2010 09:08:42 GMT

is ...

T2:
LOAD RecNo() RID,

must be ..

T2:
LOAD RecNo() as RID,

llauses@llauses.com

Adding a Sequential numbers Column

Thu, 22 Jul 2010 00:05:02 GMT

yes you are right.