Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
girish2195
Contributor II
Contributor II

Numbering based on Date and Process

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

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

View solution in original post

3 Replies
tresesco
MVP
MVP

Try like:

Load

          Autonumber(RowNo(), Process) as CounterProcess

Gysbert_Wassenaar

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;


talk is cheap, supply exceeds demand
tresesco
MVP
MVP

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

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