Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

reg-keyfield

1.how to create a key field  in qlikview

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

use autonumberhash

for example

load

...

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

its_anandrjs

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