Setting a counter flag in a script

devans_1 — Tue, 17 Jan 2012 17:54:36 GMT

Does anyone have an idea of how to create a 'counter flag' when runnign a script ? Suppose I have fields (or a combination of fields that make up the key)

AAABBBCCC

AAABBBDDD

AAABBBEEE

AAABBBCCC

I want to be able to set a flag so that I get

field Counter

AAABBBCCC 1

AAABBBDDD 2

AAABBBEEE 3

AAABBBCCC 4.

AUTONUMBER takes me partially there but this would duplicate a counter of '1' for the final AAABBBCCC. I need to have a new number for this field because of the rest of the data that is held on this field (it's complicated but it holds all sorts of numbers which I'm doing calculations on so I can't sort on any other fields - however, assuming the data is correctly ordered above, any help would be appreciated).

Setting a counter flag in a script

swuehl — Tue, 17 Jan 2012 18:10:02 GMT

Maybe like this:

LOAD Field,

if(recno()=1,1,if(peek(Field) = Field, peek(Flag),peek(Flag)+1)) as Flag

INLINE [

Field

AAABBBCCC

AAABBBDDD

AAABBBEEE

AAABBBCCC

];

Setting a counter flag in a script

devans_1 — Wed, 18 Jan 2012 17:05:05 GMT

Thanks for this. It is exactly what I needed. Works perfectly

topic Setting a counter flag in a script in QlikView

Setting a counter flag in a script

Setting a counter flag in a script

Setting a counter flag in a script