topic Re: What is mean by InLine MEmory in Qlikview ?? in QlikView

What is mean by InLine MEmory in Qlikview ??

nikhilgarg — Tue, 23 Sep 2014 11:45:08 GMT

Hey,

What is mean by InLine Memory in Qlikview ??

Thanks.

Re: What is mean by InLine MEmory in Qlikview ??

senpradip007 — Tue, 23 Sep 2014 11:47:40 GMT

Inline is used if data should be typed within the script, and not loaded from a file. Use the Inline Data Wizard for help with the creation of load inline statements.

data ::= [ text ]

Data entered through an inline clause must be enclosed by double Quotation Marks in Scripting or with square brackets. The text between these is interpreted in the same way as the content of a file. Hence, where you would insert a new line in a text file, you should also do it in the text of an inline clause, i.e. by pressing the Enter key when typing the script.

Re: What is mean by InLine MEmory in Qlikview ??

rajeshvaswani77 — Tue, 23 Sep 2014 11:49:22 GMT

if it is in memory, what you are looking for then it means that all the dashboard data is in memory for the QlikView dashboard.

Re: What is mean by InLine MEmory in Qlikview ??

sujeetsingh — Tue, 23 Sep 2014 11:52:13 GMT

Inline is used to create temp table in Qlikview.

But if you are searching for in-memory then follow this.

What is In-Memory in QlikView

Re: What is mean by InLine MEmory in Qlikview ??

Tue, 23 Sep 2014 11:55:51 GMT

Load inline will create a table in the qvw document. The table and its data will be stored in the qvw file once saved.

Once the table is created in the script data from the table can be accessed like any other table further down the script.

As an example, you create a table with the following Load inline:
mytable:
LOAD * INLINE [ Field1, Field2
ValueA1, ValueA2
ValueB1, ValueB2 ];

Now you can access this table (once loaded) further down in your script, like:
Load Field1 as NewField resident mytable;

If you save the file (after reload) and reopen you will notice that you have two fields with the data constructed in your Load inline, i.e. data is saved within the qvw document

Thanks,

TDP

Re: What is mean by InLine MEmory in Qlikview ??

maxgro — Tue, 23 Sep 2014 11:59:26 GMT

load inline is a statement

in memory is the way Qlik works:all data is in memory

more detail (much more) here

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-pointers

The underlying technology of QlikView | DBMS 2 : DataBase Management System Services