Dynamically pull specific snapshots from db to Qlik
Hi Experts, I have a huge table with more than 800 million rows. This is a snapshot table and i don't need all the snapshot data. Only require yesterday, 3 weeks ago from today and 10 weeks ago from today. Is there a way i can dynamically extract only these 3 snapshots from database to Qlik using variables?
For Example in the attached excel: i want to pull 2022/11/14 3 Weeks ago from 2022/11/14 ( - 21) 10 weeks ago from 2022/11/14 ( -70)
This should be dynamic .. tomorrow it should be 2022/11/15
3 Weeks ago from 2022/11/15 10 weeks ago from 2022/11/15
