I have a large QVD file with a lot of data, and I'm using OneDrive to upload the data to Qlik Cloud. I want to keep only the data from 2022 on the cloud and reload the data for 2023 since it keeps changing.
So, should I create an app with only the 2022 data using a script like "where date = '2022'" and upload it as a QVF to the cloud? And can I use the (Binary) load statement to connect the two apps? Will this work? Also, if I decide to do this, how can I ensure that the data loaded from the QVD for 2023 only?
You need to follow an approch to store the values which is only 2022 as a QVD and again pull the QVD to the application and concatenate with the 2023 records which keeps updating, You don't need 2 application, you can do it in the single app itself.
