https://community.qlik.com/t5/App-Development/Dynamically-pull-specific-snapshots-from-db-to-Qlik/m-p/2004985#M83173 <P>Hi Experts,<BR />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?</P> <P>For Example in the attached excel:<BR />i want to pull 2022/11/14<BR />3 Weeks ago from 2022/11/14 ( - 21)<BR />10 weeks ago from 2022/11/14 ( -70)</P> <P><BR />This should be dynamic .. tomorrow it should be 2022/11/15</P> <P>3 Weeks ago from 2022/11/15<BR />10 weeks ago from 2022/11/15</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank you,</P> <P>Ramya</P> Tue, 15 Nov 2022 22:46:35 GMT ramyasaiqv 2022-11-15T22:46:35Z https://community.qlik.com/t5/App-Development/Dynamically-pull-specific-snapshots-from-db-to-Qlik/m-p/2004985#M83173 <P>Hi Experts,<BR />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?</P> <P>For Example in the attached excel:<BR />i want to pull 2022/11/14<BR />3 Weeks ago from 2022/11/14 ( - 21)<BR />10 weeks ago from 2022/11/14 ( -70)</P> <P><BR />This should be dynamic .. tomorrow it should be 2022/11/15</P> <P>3 Weeks ago from 2022/11/15<BR />10 weeks ago from 2022/11/15</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thank you,</P> <P>Ramya</P> Tue, 15 Nov 2022 22:46:35 GMT https://community.qlik.com/t5/App-Development/Dynamically-pull-specific-snapshots-from-db-to-Qlik/m-p/2004985#M83173 ramyasaiqv 2022-11-15T22:46:35Z