# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Partner

## Calculate row number for groups

Hi All,

I have the following table (only the fields in black) and in qlikview script, I want to stamp a value GROUP_ROWNO which lets me know the Nth occurrence of MPATID based on the ascending order of CREATEDT.

Attaching the sample sheet. Can anyone help me to calculate this in (1) script side  (2) UI using set analysis

Regards

Vishnu S

Tags (4)
1 Solution

Accepted Solutions
Esteemed Contributor III

## Re: Calculate row number for groups

Dimensions:

MPATID, CASENUM, CREATEDT

Expression:

= Sum(Aggr(RowNo(),  MPATID, CREATEDT))

GetRow:

CASENUM,

CREATEDT

FROM

(ooxml, embedded labels, table is MicTest);

LEFT JOIN(GetRow)

Final:

CREATEDT,

IF(MPATID <> Previous(MPATID), 1, Peek('GroupRow')+1) AS GroupRow

Resident GetRow

Order By MPATID, CREATEDT;

4 Replies
Esteemed Contributor III

## Re: Calculate row number for groups

Dimensions:

MPATID, CASENUM, CREATEDT

Expression:

= Sum(Aggr(RowNo(),  MPATID, CREATEDT))

GetRow:

CASENUM,

CREATEDT

FROM

(ooxml, embedded labels, table is MicTest);

LEFT JOIN(GetRow)

Final:

CREATEDT,

IF(MPATID <> Previous(MPATID), 1, Peek('GroupRow')+1) AS GroupRow

Resident GetRow

Order By MPATID, CREATEDT;

Luminary

## Re: Calculate row number for groups

Hi,

In script it would be something like this:

```LOAD
MPATID,
CASENUM,
CREATEDT,
If(MPATID=Peek(MPATID), Peek(GROUP_ROWNO)+1, 1)     as GROUP_ROWNO
FROM Source
Order By
MPATID,
CREATEDT
;
```

For chart expression you could try playing with Rank() but it is a bit tricky:

```Rank(-CREATEDT)
```

Hope this helps.

Juraj

Luminary

## Re: Calculate row number for groups

OMG, this is so elegant.

Partner

## Re: Calculate row number for groups

Perfect. Thanks Viswarath.