Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dmpilars
Partner - Creator
Partner - Creator
‎2018-02-14 08:14 AM

Generate counter by groups

Hi People!

Please Help me, I try to make a consecutive number like this:

COD               NIT             Consecutive

00000          123456          000001

00000          123456          000001

00000          123456          000001

00000          123456          000001

00000          234567          000002

00000          234567          000002

00000          234567          000002

00000          234567          000002

00009          345678          000003

00009          345678          000003

00010          345678          000003

00010          345678          000003

00011          345678          000003


I need to assign the consecutive number and this depends on NIT and COD value.

836 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2018-02-15 03:37 PM

In response to sunny_talwar

Check this script

Table:

LOAD RowNo() as RowNum,

*,

Num(AutoNumber([NIT&COD1], Left([NIT&COD1], 7)), '000000') as CONSEC;

LOAD * INLINE [

    NIT&COD1

    500096929000000

    500096929000000

    500096929000000

    500096929000001

    500096929000001

    500096929000001

    500096929000002

    500096929000002

    500096929000002

    500096929000009

    500096929000009

    500096929000009

    500122959000955

    500122959000955

    500122959000955

    500129157000959

    500129157000959

    500129157000959

    500129157000960

    500129157000960

    500129157000960

    500150250000012

    500150250000012

    500150250000012

];

Capture.PNG

View solution in original post

291368.qvw
695 Views
0 Likes
12 Replies
sunny_talwar
MVP
MVP
‎2018-02-14 08:17 AM

It seems to be only dependent on NIT... May be this

Num(AutoNumber(NIT), '000000') as Consecutive

537 Views
zebhashmi
Specialist
Specialist
‎2018-02-14 08:19 AM

I would say

Hash128(COD,NIT) as Consecutive,

537 Views
0 Likes
OmarBenSalem
MVP
MVP
‎2018-02-14 08:19 AM

as I see it's only based on NIT no?

and do u want it on the script or in a table? without altering the script?

537 Views
0 Likes
dmpilars
Partner - Creator
Partner - Creator
‎2018-02-15 02:03 PM
Author

In response to sunny_talwar

My calculation conditions changes. Now I need to make this:

COD            NIT&COD1     CONSEC

00009          123450001     000001

00009          123450001     000002

00009          123450001     000003

00009          123450002     000001

00009          123450002     000002   

00009          123450003     000001   

00009          123450004     000002

00010          456780001     000001

00010          456780002     000001  

00010          456780002     000002

How I can enumerate in this form?

537 Views
0 Likes
dmpilars
Partner - Creator
Partner - Creator
‎2018-02-15 02:04 PM
Author

In response to OmarBenSalem

I need to do that in the script

537 Views
0 Likes
sunny_talwar
MVP
MVP
‎2018-02-15 02:07 PM

In response to dmpilars

This

Num(AutoNumber(RowNo(), COD&NIT&COD1), '000000') as CONSEC

537 Views
0 Likes
dmpilars
Partner - Creator
Partner - Creator
‎2018-02-15 03:07 PM
Author

In response to sunny_talwar

                        NIT&COD1               CONSEC

50009692900000000001
50009692900000000001
50009692900000000001
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000200003
50009692900000200003
50009692900000200003
50009692900000200003
50009692900000200003
50009692900000200003
50009692900000200003
50009692900000900004
50009692900000900004
50009692900000900004
50009692900000900004
50009692900000900004
50009692900000900004
50009692900000900004
50009692900000900004
50009692900000900004
50012295900095500001
50012295900095500001
50012295900095500001
50012295900095500001
50012295900095500001
50012295900095500001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700096000002
50012915700096000002
50012915700096000002
50012915700096000002
50012915700096000002
50012915700096000002
50012915700096000002
50015025000001200001
50015025000001200001
50015025000001200001
50015025000001200001
50015025000001200001

And, have you any idea for this format?

537 Views
0 Likes
sunny_talwar
MVP
MVP
‎2018-02-15 03:18 PM

In response to dmpilars

Not sure I understand the question? Can you elaborate?

537 Views
0 Likes
dmpilars
Partner - Creator
Partner - Creator
‎2018-02-15 03:30 PM
Author

In response to sunny_talwar

In this case I need a consecutive code that correspond with NIT&COD1 but when NIT&COD1 changue, the consecutive start in 00001 again. This data is in groups.

NIT( first 9 characters); COD1(next 6 characters);  COD1 define a new group on master group defined by NIT. When NIT changues The consecutive should start in 00001 again.

NIT&COD1                  CONSEC

50009692900000000001
50009692900000000001
50009692900000000001
50009692900000100002
50009692900000100002
50009692900000100002
50009692900000200003
50009692900000200003
50009692900000200003
50009692900000900004
50009692900000900004
50009692900000900004
50012295900095500001
50012295900095500001
50012295900095500001
50012915700095900001
50012915700095900001
50012915700095900001
50012915700096000002
50012915700096000002
50012915700096000002
50015025000001200001
50015025000001200001
50015025000001200001
537 Views
0 Likes