Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
MVP
MVP

Try like:

Load

          Autonumber(RowNo(), Process) as CounterProcess

MVP & Luminary
MVP & Luminary

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
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