topic Generate a calculated column with serial numbers for a straight table in App Development

Generate a calculated column with serial numbers for a straight table

saurabh_Qlik1 — Fri, 15 Nov 2024 21:02:58 GMT

I have a straight table containing 600 Rows of data. These 600 rows are divided in 3 groups based on a date. So each set of 200 rows of data pertain to a particular date (which is also one of the columns in the dataset). These rows are jumbled and not sorted based on date.

I am trying to generate a calculated column (field) that contains serial numbers for each of the set of 200 rows. So 1 to 200 for one set belonging to a particular date, then again 1 to 200 for the next set and so on.

However, I want this as a calculated column and not a measure.

Please help!

Re: Generate a calculated column with serial numbers for a straight table

Vaibhav_Pathak — Wed, 28 Feb 2024 06:44:23 GMT

Use RowNo() function in Load script to get serial number(1 to 600) for all the records.

Re: Generate a calculated column with serial numbers for a straight table

saurabh_Qlik1 — Wed, 28 Feb 2024 06:46:24 GMT

Thanks @Vaibhav_Pathak for your reply.

I have modified my question a bit. Will you be able to provide a solution to the updated question?

Thanks for your help!

Re: Generate a calculated column with serial numbers for a straight table

saurabh_Qlik1 — Wed, 28 Feb 2024 06:49:27 GMT

Also, is there a way to do this via Data Manager? I see my load script is locked.

Re: Generate a calculated column with serial numbers for a straight table

rwunderlich — Wed, 28 Feb 2024 18:04:34 GMT

You can generate the serial numbers on the script with:

AutoNumber(RecNo(), DateField) as Serial

-Rob

Re: Generate a calculated column with serial numbers for a straight table

saurabh_Qlik1 — Tue, 05 Mar 2024 05:01:43 GMT

thanks @rwunderlich for your response. Is it possible to achieve this via Data Manager?

I see functions like AutoNumber or RecNo cannot be applied using Data Manager.

Re: Generate a calculated column with serial numbers for a straight table

rwunderlich — Tue, 05 Mar 2024 15:55:36 GMT

Qlik made a design choice to exclude script only functions from the Data Manager calculated field dialog. I suppose because they cannot be calculated in the preview window.

-Rob