Difference between ODBC and OLEDB in Qlikview

in one bite :: we commonly used functionality in qv while connect to db. here is the issue we know all of us use OLEDB why it is Preferable here i go with simple words... ODBC : we can use this and access only relational database's such as oracle,mysql, mssql like,, using...

Read More

Execute particular lines of script only in Qlikview

Check this link for detailed explanetion->  Execute particular lines of scrip...

Read More

Partial Reload in Qlikview

Use: This command executes only Load and Select (SQL) statements preceded by a Replace or Add prefix. Other data tables remain unaffected by the command. detail view:  Execute particular lines of script inns-ted of executing entire script it can be useful. -To perform this load we need to give ADD qualifier before LOAD or SELECT statement. -To...

Read More

binary Load in Qlikview

Use: The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables. Only one binary statement is allowed in the script and it can only be put as the first statement of a script.   detailview: Binary customer.qvw; Binary c:\qv\customer.qvw; The...

Read More

Resident Load in Qlikview

use: is used if data should be loaded from a previously loaded table. detailview If we want to access data from all-ready used table in a document we need to perform resident load. First i have created table1 table1: LOAD Company,      Sales,      Year FROM [C:\Users\ZampanY\Desktop\yearsales.QVD](qvd); table2: LOAD...

Read More

Optimized QVD in Qlikview

while creating QVD file when you press reload in Edit script window you can observe there it display the file optimized (when you done fetching all the data) The Qlikview create and compress and store the data into QVD. An optimized load the data is sent directly from disk to memory directly in the same compressed format. and the QVD loads with...

Read More

how to create a qvd file in qlikview

We can create QVD files in three ways 1) The basic way using the name STORE command in the qlikview script ex: store tablename into E:\suvidocuments\ownname.qvd; STORE: is a command to store all the data into some another file tablename: is a name which you have named what data you want to create to QVD file [while creating qvd file it search for...

Read More