You could save a copy of your original qvw and then use that in a binary load (load from qlikview files) to bring in the old data. you can also then use a store command to save the data to qvds.. Team. i am having millions of records in the table , i tried to load and save the data in the qlikview, it is taking 6 to 7 hours to load and save the data in qlikview. any suggestions how to minimize the data load time.. Consider 3-6 of c#/.net developpement with netoffice libraries and you might save more time for the future and everything will work automatically, only things you still have to create is a qlikview report, drag and drop the objects you want to show in your powerpoint/excel, instead of doing every month again a new report by hand..
Qlik sense gives you data superpowers. easily combine all your data sources, no matter how large, into a single view. qlik’s associative engine indexes every possible relationship in your data so you can gain immediate insights and explore in any direction your intuition takes you. unlike query-based tools, there’s no pre-aggregated data and predefined queries to hold you back.. In a qlikview application, when data is loaded from one line then it is called a binary load. in a binary load the data model of the qvw file is copied into another qvw file. example. Qlikview can process files from the web, which are in the html format. it can extract data from html tables. the url of the web file to be processed is given as an input and qlikview fetches both, the structure and content of the file..