Conditional relations

[Anonymous]

Hello,

I cannot find info on how to make conditional relations between tables. My data structure example (where are more conditional links to other tables):

Any suggestions and examples would be appreciated. I am new to Qlik Sense and got stuck on this issue.

[vinieme12]

i don't understand the question, what do you mean by conditional relations?

can you post some sample data in excel that best represents the data set's you are working with

[Anonymous]

why u don't concatenate the two table (people and project) or outer join this two table in script

and set condition on name field  in your expression

[Anonymous]

Data sample attached.

I am receiving items and parameters data as json and Qlik handles the realtion by creating key column.

[Anonymous]

As I have mentioned I have more tables and they have different business logic so concatenate might not be good.

But your suggestion gave me fought that I could merge items and parameters tables like this:

Item	Name	Project	Assignee	...
data	data	data	data	...

Maybe someone could explain me how to achieve this because I am using REST adapter and Qlik gets data as different tables.

[vinieme12 · Accepted solution]

Read this thread, this is exactly what you need.

The Generic Load

Sample Generic Load Script

[Anonymous]

Thank you. It looks like what I was looking for. I will try it out.

EDIT:

I have tried it and found out that there is even more complex relations within properties table, so I have wrote an nodejs script witch converts data and then I am loading it to Qlik. Thank you for help.