Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to Qlikview? Help for this Question
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
];
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.