Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

is there any loads in qlikview getting data without hitting db?

Hi,

I am new to Qlikview? Help for this Question

Tags (1)
2 Replies
Not applicable

Re: is there any loads in qlikview getting data without hitting db?

s you can by using inline load

inline load: where we dont have database we can create by using inline load

ex:

load * inline

[

products,amount

apple,100

banana,200

];

Re: is there any loads in qlikview getting data without hitting db?

All LOAD statements load data from either local table files (text files, excel files, xml files etc.), resident tables, local listings (see manojqlik's example), from an AUTOGENERATE expression, from a subsequent LOAD, from a field, but never from a DB.

To load data from a database, QlikView uses either SQL SELECT or other QlikView Connector-dependent statements.

Search for the LOAD statement help in QlikView Desktop Help for an in depth explanation.