The extension of an qlikview application is qvw. We can load data into the qlikview application(.qvw) in many ways using the script editor. Let us discuss few of them:
1. OLEDB Connection:
By connecting to database and selecting the columns list from tables.
2. ODBC Connection:
Creating an database connection in local machine and accessing it in the qlikview applications.
3. Load data from files:
We can load data from files such as Excel, CSV, TXT, XML, or even HTML. While loading the data we can select the columns we needed.
4. Qlikview Applications:
This comes into use when we follow 3-tier architecture where same data is used in more than one application.
5. Web files:
When we want to load data from a web file, we can provide the url and load the data.
6.Load data from Qvd:
This comes into use when we follow 3-tier architecture where data is loaded into qvd files from database in another qlikview application.