Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Conditional relations

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):

Diagram.png

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

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Read this thread, this is exactly what you need.

The Generic Load

Sample Generic Load Script

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

6 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

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
Not applicable
Author

Data sample attached.

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

Anonymous
Not applicable
Author

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:

ItemNameProjectAssignee...
datadatadatadata...

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

vinieme12
Champion III
Champion III

Read this thread, this is exactly what you need.

The Generic Load

Sample Generic Load Script

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

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.