Create associations between qvd using script

[NewToQlikSens]

Hi all,

How do I make associations/relationship between different qvd's?

Ex: I have 2 qvd ----- Product.qvd - (Name and Price) and Department.qvd -(DeptName and Designation)

I want to form an association/relation between Product.Name and Department.DeptName using script only.

How do i do that? The datatype of the fields are the same.. but the name is different(has to be different, a requirement).

Any insights would be really helpful

[Clement15]

Hello,

You can use the Autonumber() function in both tables.

Autonumber(Product.Name) as Id

Autonumber(Department.DeptName) as Id

This will create a common id for identical values.

autonumber - script function | QlikView Help

[NewToQlikSens]

Will try with this. Thanks.