topic Re: I'm having a script problem. in QlikView

I'm having a script problem.

Ribeiro — Wed, 29 Nov 2017 18:54:43 GMT

When it's the same

TMP:

LOAD * Inline

[

field,Rep

123123,5

312312,5

312314,5

];

The Rep record does not let itself be repeated, it is giving this error.

Example below it leaves because the REP field are different

Here it works because REP is different





TMP:
LOAD * Inline
[
field,Rep
123123,5
312312,3
312314,8
];




FOR i = 1 TO NoOfRows('TMP')


LET vTbl = FieldValue('field', $(i));
LET vCon = previous(FieldValue('Rep',     $(i)));
  TRACE $(vCon);


sumary:
LOAD '$(vTbl)' AS MyField,
$(vCon)  AS MyRep,
RecNo()  AS CONT


AutoGenerate $(vCon)
;




NEXT 




DROP Table TMP;
EXIT Script;

Re: I'm having a script problem.

luismadriz — Wed, 29 Nov 2017 23:01:10 GMT

Hi,

You may want to use this instead?

LET vTbl = Num(Peek('field', i-1, 'TMP'));

LET vCon = Num(Peek('Rep', i-1, 'TMP'));

I hope it helps,

Cheers,

Luis

Re: I'm having a script problem.

Ribeiro — Wed, 29 Nov 2017 23:39:51 GMT

Obrigado Luiz. Estava com presa.