topic How can I load only the last 3 years data in QlikSense? in App Development https://community.qlik.com/t5/App-Development/How-can-I-load-only-the-last-3-years-data-in-QlikSense/m-p/1423357#M33884 <HTML><HEAD></HEAD><BODY><P>The date field is only available in one table S. I have table P, S, PA, SA, RT. P is related to S. S is related to PA. S is also related to SA. P is related to RT.</P><P></P><P>I can restrict the load of only past 3 years data in table S using the where clause. But how do I do it for the other tables? Do I have to join them together? How can I do it in Qlik? Thanks!</P></BODY></HTML> Tue, 07 Nov 2017 01:14:09 GMT Anonymous 2017-11-07T01:14:09Z How can I load only the last 3 years data in QlikSense? https://community.qlik.com/t5/App-Development/How-can-I-load-only-the-last-3-years-data-in-QlikSense/m-p/1423357#M33884 <HTML><HEAD></HEAD><BODY><P>The date field is only available in one table S. I have table P, S, PA, SA, RT. P is related to S. S is related to PA. S is also related to SA. P is related to RT.</P><P></P><P>I can restrict the load of only past 3 years data in table S using the where clause. But how do I do it for the other tables? Do I have to join them together? How can I do it in Qlik? Thanks!</P></BODY></HTML> Tue, 07 Nov 2017 01:14:09 GMT https://community.qlik.com/t5/App-Development/How-can-I-load-only-the-last-3-years-data-in-QlikSense/m-p/1423357#M33884 Anonymous 2017-11-07T01:14:09Z Re: How can I load only the last 3 years data in QlikSense? https://community.qlik.com/t5/App-Development/How-can-I-load-only-the-last-3-years-data-in-QlikSense/m-p/1423358#M33885 <HTML><HEAD></HEAD><BODY><P>You can Restrict data in Table S.</P><P>Join P,PA,SA to this Table and then Restrict Data in RT according to joined data</P></BODY></HTML> Tue, 07 Nov 2017 09:43:16 GMT https://community.qlik.com/t5/App-Development/How-can-I-load-only-the-last-3-years-data-in-QlikSense/m-p/1423358#M33885 shraddha_g 2017-11-07T09:43:16Z