1 Reply Latest reply: Nov 7, 2017 4:43 AM by Shraddha Gajare RSS

    How can I load only the last 3 years data in QlikSense?

    Wayne Loo

      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.

       

      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!