Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriele_qlik
Contributor II
Contributor II

SAME KEY FIELD VALUES IN DIFFERENT APPS

Hi at all.

Suppose I have two table. First table is:

[

     Name,Age

     Jhon,18

     Mark,30

     Anne,25

]

Second Table is:

[

     Name,Nation

     Anne,Italy

     Carlos,Spain

     Jhon,Scotland

     Richard,U.S.A.

     Mark,Germany

]

Now I create two apps and I load first table in first app and second table in second app.

I want to create a key field with Name Field.

If I use autonumber function, in the first app, for example, Jhon has 1 value in autonmber field while in the second app he has 3 value in autonumber field.

If I use hash128 function, Jhon, Mark and Anne have same key field values in the first and in the second app but key field values are not numeric.

I want result of hash128 function but with numeric values.


IS THERE A METHOD?


P.s. AutonumberHash128() function in not correct

1 Reply
agigliotti
Partner
Partner

what are you trying to achieve?