Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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!

1 Reply
shraddha_g
Partner - Master III
Partner - Master III

You can Restrict data in Table S.

Join P,PA,SA to this Table and then Restrict Data in RT according to joined data