topic Re: hard code ID in QlikView

hard code ID

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We need to create an ID like

ID = 90001,90002,9003...................

I have used 9000+rowno()

but it gives some random results like 9006,90010......

Thanks..

sunny_talwar — Wed, 24 Jan 2018 12:33:42 GMT

May be try with RecNo() and see if that helps?

9000 + RecNo()

jonathandienst — Wed, 24 Jan 2018 12:35:41 GMT

Do you mean in script or in a chart/table?

nareshthavidishetty — Wed, 24 Jan 2018 12:37:25 GMT

In Script

nareshthavidishetty — Wed, 24 Jan 2018 12:40:53 GMT

Hi,

Both gives same results.

Please find below.

Thanks..

jonathandienst — Wed, 24 Jan 2018 12:49:50 GMT

Then it would seem that something is removing the other lines, such a a join later in the script.

RowNo() is a count of the output from the load statement. RecNo() is a count of the input and can be affected by a where clause.

I suggest that you post more information about your load script if you would like more detailed help.

sunny_talwar — Wed, 24 Jan 2018 12:52:12 GMT

Do you have where clause or Left/Right Joins/Keeps?

nareshthavidishetty — Wed, 24 Jan 2018 13:00:14 GMT

yes! We have left join.