topic Autogenerate records based on fields in QlikView

Autogenerate records based on fields

Mon, 14 May 2012 18:54:44 GMT

I'm trying to autogenerate records based on 2 fields. Start Operation and End Operation. e.g. 10 -50. I need to generate records by increments of 10. Therefore, i would have 10, 20, 30 , 40, 50 for this particular record. It also needs to be dynamic for each record since the start and end operation will vary by record. Any ideas?

Autogenerate records based on fields

swuehl — Mon, 14 May 2012 19:36:44 GMT

Maybe like this?

LOAD Value,

StartOperation+(iterno()-1)*10 as Operation

while StartOperation+(iterno()-1)*10<=EndOperation;

LOAD * INLINE [

Value, StartOperation, EndOperation

10, 10, 50

];

Autogenerate records based on fields

Mon, 14 May 2012 20:14:01 GMT

Thanks!!