topic Re: Serial Number Generation In Load Script in QlikView

Serial Number Generation In Load Script

ajithsachin — Tue, 27 Jan 2015 05:04:38 GMT

Hi All,

I need to create a serial number in the load script , but i need to reset to this again 1 when there is a change in the code.

Suppose my table is like this

itemcode,supplier

in this load when itemcode change that time need to reset the serial number to 1.

Can anybody help.

Regards,

Ajith

jonathandienst — Tue, 27 Jan 2015 05:16:33 GMT

This code should do it:

LOAD

...

itemcode,

supplier,

if(itemcode = previous(itemcode), peek('serialno') + 1, 1) as serialno,

...

HTH

Jonathan

ajithsachin — Tue, 27 Jan 2015 05:30:29 GMT

Thank You.