topic AutoGenerate in Group in QlikView

AutoGenerate in Group

maxsheva — Wed, 19 Apr 2017 05:31:55 GMT

Hi,

What is the way to generate NUMBERS for text for each group?

Table1:

LOAD * INLINE [

Example, Date, Value1

Group1, Example1, 70

Group1, Example2, 50

Group1, Example3, 20

Group2, Example1, 10

Group2, Example2, 100

Group3, Example1, 70

Group3, Example2, 70

Group3, Example3, 70

];

A result I need

Num, Example, Date, Value1

1, Group1, Example1, 70

2, Group1, Example2, 50

3, Group1, Example3, 20

1, Group2, Example1, 10

2, Group2, Example2, 100

1, Group3, Example1, 70

2, Group3, Example2, 70

3, Group3, Example3, 70

];

Thx.

tresB — Wed, 19 Apr 2017 05:36:04 GMT

Try:

Table1:

LOAD AutoNumber(RowNo(),Example) as Num,

* INLINE [

Example, Date, Value1

Group1, Example1, 70

Group1, Example2, 50

Group1, Example3, 20

Group2, Example1, 10

Group2, Example2, 100

Group3, Example1, 70

Group3, Example2, 70

Group3, Example3, 70

];

prma7799 — Wed, 19 Apr 2017 05:49:17 GMT

Please check below