topic Numbering based on Date and Process in QlikView

Numbering based on Date and Process

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

Hi All,

Please find the below attachment for sample data.

I want to generate the number based on date and process.

If you look at the sample data you will get the idea.

Thanks in advance

Girish Kumar DV

tresB — Wed, 20 Dec 2017 12:54:45 GMT

Try like:

Load

Autonumber(RowNo(), Process) as CounterProcess

Gysbert_Wassenaar — Wed, 20 Dec 2017 12:57:16 GMT

Perhaps like this:

tmpUnsorted:

LOAD

Date,

Process

FROM

...source...

;

Result:

NOCONCATENATE LOAD

Date,

Process,

If(Date=Previous(Date) And Process=Previous(Process), peek(Number)+1, 1) as Number

RESIDENT

tmpUnSorted

ORDER BY

Date,

Process

;

DROP TABLE tmpUnsorted;

tresB — Wed, 20 Dec 2017 13:02:36 GMT

Now I notice that your Number also considers Date field. Try like:

AutoNumber(RowNo(),Process & Date) as Number