topic Re: recno() in inline in QlikView

recno() in inline

Wed, 28 Jan 2015 09:05:31 GMT

load

recno(),Customer, Value from inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

can any 1 help me y the above script gives error?

I wan recno followed by customer, value.

Re: recno() in inline

marcus_sommer — Wed, 28 Jan 2015 09:07:32 GMT

Try:

load

recno() as RecNo, * inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

- Marcus

Re: recno() in inline

alexandros17 — Wed, 28 Jan 2015 09:08:33 GMT

this works, simply delete the from clause

load
recno(),Customer, Value
inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

Re: recno() in inline

jagan — Wed, 28 Jan 2015 09:30:03 GMT

Hi,

Remove From clause and use below script

TableName:

load

recno() AS RecordNumber,Customer, Value inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

Hope this helps you.

Regards,

Jagan.

Re: recno() in inline

its_anandrjs — Wed, 28 Jan 2015 09:33:09 GMT

Hi,

You can try also

load
Recno() as RecNO,RowNo() as RowNO
,Customer, Value
inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];

Regards

Anand

Re: recno() in inline

Wed, 28 Jan 2015 10:52:16 GMT

thank u all,

I got in this way:

load

Customer, Value ,RowNo() as number inline [
Customer, Value
infy, 20
tcs, 30
infy, 10
tcs, 15
google, 40
google, 400
accenture,353
ibm,3625
accenture,245
];