Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vvira1316
Specialist II
Specialist II

How to use certain field values of a parent record while working with a sub record in a set analysis

Hi,

I've situation where I've to do calculation in set analysis where I'm working on record with CPDID 330398 from information included below. It is a sub record that is identified using "Rec Type" field. It is to be included in selection based on some criteria say "Created Date" or "Aging - Last Updated" field values of record "CPDID 60218", "Rec Type Main - Generic"

Is it possible to do check on a record or work with a record (sub) and use another record (parent/main) for certain condition is met in main/parent record

MainSubDoc.png

Let me know if any more information/clarification is required.

Thanks,

Vijay

1 Reply
vvira1316
Specialist II
Specialist II
Author

I achieved it by created another table with related information from the main table that is linked using ID column.