Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

how to generate the serial number as per the data lines uploaded?

Dear All,

I have made a scatter chart which shows the contract expiring date, material & its value.

There are many contracts with same contract number linked to a specific material having different value. so we want to show as two different bubbles.

To seperate similar contract number cases, i have added a serial number field as the dimention to show the data.

Every time i have to upload a new excel sheet, I have to update the serial numbers.

Is it possible to generate serial number automatically depending upon the data lines uploaded & use it as a dimention.

Thanks in advance!

Best Regards

Rahul Kale

1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: how to generate the serial number as per the data lines uploaded?

Hi,

You can auto generate a counter field to a table using Rowno() for example

2 Replies
jsn
Honored Contributor

Re: how to generate the serial number as per the data lines uploaded?

Hi,

You can auto generate a counter field to a table using Rowno() for example

Not applicable

Re: how to generate the serial number as per the data lines uploaded?

Gr8 Thanks it works!

You made my day!

Community Browser