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

Issue with circular referance.

Hi,

I have a table users which has a user_id, valid_from_date , valid_to_date and lot of other columns that I need. Another table search which has user_id , search _date (contains those users who have performed a search). I have a time table which I have to join to these two tables to get actual date.

I have a filter for year, quater and month . A filter which needs to select users who have performed search.(I need to join search and users with user_id)

I need to show two charts:

1. Using users table and time table (I have used interval match and inflated the data to get date of valid users from valid_from_date and valid_to_date)

2. The second chart needs users in search table , now this table needs to join with the time table on search_date.

so I have users join with search , which joins with time table and time table join with users.

I cant avoid circular ref!

Please help!

How can these two charts be implemented

Thanks,

Saloni

1 Reply
Not applicable
Author

Hi

Could You post here table view of Your file?