topic Re: reg-keyfield in QlikView

reg-keyfield

Mon, 24 Mar 2014 10:03:59 GMT

1.how to create a key field in qlikview

alexandros17 — Mon, 24 Mar 2014 10:05:55 GMT

use autonumberhash

for example

load

...

autonumberhash128(fld1, fld2, ... fldn) as myKey

its_anandrjs — Mon, 24 Mar 2014 10:24:28 GMT

Hi,

You can create it with different types like

load

autonumber( Region&Year&Month ) as %Key1,

autonumberhash128 ( Region, Year, Month ) as %Key2,

Autonumberhash256 ( Region, Year, Month ) as %Key3

Year&Month as %Key4

From Location;

Hope this helps

Thanks & Regards