Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1.how to create a key field in qlikview
use autonumberhash
for example
load
...
autonumberhash128(fld1, fld2, ... fldn) as myKey
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