topic Re: Create incremental field in QlikView

Create incremental field

Wed, 22 Oct 2014 08:09:36 GMT

Hi,

I am looking to set up a field that is incremented automatically by one for each field in my Billing, to create each KPI KPI_ID on my field.

Do you have any idea?

anbu1984 — Wed, 22 Oct 2014 08:20:08 GMT

Can you explain your requirement with sample data and expected output

Wed, 22 Oct 2014 08:23:46 GMT

I've got the field Metric, and i want to create Metric Id.

is it ok for you ?

rustyfishbones — Wed, 22 Oct 2014 08:26:07 GMT

You can use

RowNo() as MetricID

or try creating an inline Table and Assign your metrics with an ID

Regards

Alan

anbu1984 — Wed, 22 Oct 2014 08:26:30 GMT

Use RowNo()

Load *,RowNo() As MetricId Inline [

Metric

User Experience

Business Transaction

Basepage

iFrame ];

Wed, 22 Oct 2014 08:32:19 GMT

i did it first with an Inline, but the number of KPI will change in the time.

Wed, 22 Oct 2014 08:32:57 GMT

i tried your solution, but the distinct doesn't work. i've got more then 1000 records.

anbu1984 — Wed, 22 Oct 2014 08:47:21 GMT

Try AutoNumber(Metric)

Wed, 22 Oct 2014 08:50:35 GMT

well done

i forgot this function.