It's not possible to include such a condition directly into the peek-function but you could imbed the peek-function within multiple nested if-loops - whereby this would only work if you knows the max. number of iterations and they are not more than 99 (it's a qlikview limitation by nested if-loops) and it would be neither very elegant nor very performant - but by smaller datasets it could be a pragmatism solution.
Another way might be to aggregate the fieldvalues from Category per concat and join them back to your originate table and to count the number of values within the aggregation and using then further string-functions like index(), subfield() and so on to pick the right value - it's probably not very easy and it will need some efforts. In general I mean somehing like this:
table:
load
AnyID, Category, if(AnyID = previous(AnyID), peek('IterNo') + 1, 1) as IterNo
resident Source order by AnyID;
left join (table)
load
AnyID,
concat(Category, ',', Iterno) as CategoryConcat,
concat(IterNo, ',', Iterno) as IternoConcat,
substringcount(concat(Category, ',', Iterno), ',') + 1 as CountConcat
resident table;
Further approach might be to create a separate table with this aggregation and running over them a for-loop to grab each record and within this loop are another for-loop or a while-loop probabaly with some furter if-checks to create some new table or just to join the right value to your originate table.
I hope this will give you some ideas what might be possible to get nearer to your goal.
- Marcus
