Serial Number on Dimension

[noman212]

Hi Friends,

How can i add Serial number based on multiple dimension.

i want to do this on calculated dimension bases in a pivot table.

Awaiting your reply.

Regards

Noman khan

[ajsjoshua]

Hi,

use

=rowno() or rowno(total).

Regards,

Joshua.

[ajsjoshua]

Hi,

check this Row Counter in Chart

[Chanty4u]

Am not sure

Do you mean RowNo() and RecNo()?

RecNo( )

Returns an integer for the number of the currently read row of the source data table. The first record is

number 1.

RowNo( )

Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to

RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that

are excluded by where clauses and is not reset when a raw data table is concatenated to another. The first

row is number 1.

[noman212]

Not working.

i have 3 dimensions

Category , Brand , and SKU..

Category = Perfume

Brand = body spray

          = ABC

          =  XYZ

BODY SPRAY's SKU

SKU =

1. ABC
2.           CDE
3.           EFG
4.              HIJ
5.            XYZ

[ajsjoshua]

Hi,

rowno(total) should work for multiple dimensions .

if not provide some sample in excel.

[noman212]

SCENERIO:

i have 3 dimensions

Category , Brand , and SKU..

Category = Perfume

Brand = body spray

          = ABC

          =  XYZ

BODY SPRAY's SKU

SKU =

1. ABC
2.           CDE
3.           EFG
4.              HIJ
5.            XYZ

i want serial no. on SKU based on Brand

[#8]

Try at script level & create like below,

Load *, autonumber(SKU) as SerialNo resident source;

[Kushal_Chawda]

Create the Expression as

=Rowno(Total)

[ajsjoshua]

Hi,

achieved both in exp and script

PFA