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
Thank you,
Ramya