topic Re: Issue with circular referance. in QlikView https://community.qlik.com/t5/QlikView/Issue-with-circular-referance/m-p/468405#M1156076 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Could You post here table view of Your file?</P></BODY></HTML> Tue, 26 Feb 2013 12:15:52 GMT 2013-02-26T12:15:52Z Issue with circular referance. https://community.qlik.com/t5/QlikView/Issue-with-circular-referance/m-p/468404#M1156075 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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. </P><P></P><P>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)</P><P>I need to show two charts:</P><P>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)</P><P>2. The second chart needs users in search table , now this table needs to join with the time table on search_date.</P><P></P><P>so I have users join with search , which joins with time table and time table join with users.</P><P></P><P>I cant avoid circular ref!</P><P></P><P>Please help!</P><P>How can these two charts be implemented</P><P></P><P>Thanks,</P><P>Saloni</P></BODY></HTML> Mon, 25 Feb 2013 18:28:05 GMT https://community.qlik.com/t5/QlikView/Issue-with-circular-referance/m-p/468404#M1156075 2013-02-25T18:28:05Z Re: Issue with circular referance. https://community.qlik.com/t5/QlikView/Issue-with-circular-referance/m-p/468405#M1156076 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Could You post here table view of Your file?</P></BODY></HTML> Tue, 26 Feb 2013 12:15:52 GMT https://community.qlik.com/t5/QlikView/Issue-with-circular-referance/m-p/468405#M1156076 2013-02-26T12:15:52Z