topic Re: generate values grouping wise in QlikView

generate values grouping wise

Thu, 11 Aug 2016 09:40:41 GMT

Hi ,

I want to show serial values like above , means for each group values starting from 1 .?How can i do ,please suggest

sunny_talwar — Thu, 11 Aug 2016 09:57:29 GMT

May be try this:

AutoNumber(RowNo(), shade) as s_index

sunny_talwar — Thu, 11 Aug 2016 09:59:41 GMT

Sample script:

Table:

LOAD *,

AutoNumber(RowNo(), shade) as s_index;

LOAD * Inline [

shade

];

Output:

Thu, 11 Aug 2016 11:24:08 GMT

Thanks sunny