topic Re: Creating a Range for a Defined list of values in QlikView

Creating a Range for a Defined list of values

shaunsomai — Wed, 19 Aug 2015 14:26:20 GMT

I have this set of data

Need to get it like this

To be done in the script

Any Help Apprreciated

maxgro — Wed, 19 Aug 2015 14:54:45 GMT

SCRIPT

LOAD

rowno() as id,

[Account Group1],

ACCTSEGVAL

FROM

(html, codepage is 1252, embedded labels, table is @1);

load

if(ACCTSEGVAL=Peek(ACCTSEGVAL)+1, peek(Group), alt(Peek(Group),0)+1) as Group

Resident a

order by id;

final:

load

[Account Group1],

Start,

if(End=Start, null(), End) as End;

load

Group,

[Account Group1],

min(ACCTSEGVAL) as Start,

max(ACCTSEGVAL) as End

Resident b

group by Group, [Account Group1];

DROP Table a, b;

RESULT