topic Re: Create associations between qvd using script in Integration, Extension & APIs

Create associations between qvd using script

NewToQlikSens — Wed, 14 Feb 2024 11:00:46 GMT

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 — Wed, 14 Feb 2024 13:30:12 GMT

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 — Thu, 15 Feb 2024 13:10:51 GMT

Will try with this. Thanks.