topic Re: Inline table in QlikView

Inline table

prasadreddy — Fri, 08 Mar 2013 11:47:18 GMT

Hi Community, can any one explain what is 'Inline'? Inline Load

Re: Inline table

sushil353 — Fri, 08 Mar 2013 11:52:02 GMT

Using inline load. you can load data manually to qlikview..

It is XL like utility in edit script.

goto insert tab> Load Statement> Inline Load.

for more you can go through qlikview refrence manual or qlikview help.

HTH

sushil

Re: Inline table

prasadreddy — Fri, 08 Mar 2013 11:59:48 GMT

Hi sushil, thanx for reply,

but still i am not understanding 'Load Inline'

Re: Inline table

Fri, 08 Mar 2013 12:03:41 GMT

Hello Prasad,

What is that you are not able to understand in 'Load Inline' ? Is it how QV interprets it or how to use it?

Thanks,

itsangad

Re: Inline table

Gabriel — Fri, 08 Mar 2013 12:11:53 GMT

Hi Prasad,

INLINE LOAD helps you load data not on file (i.e excel file, access file and any other file format), into qlikview and fill in gap or solve other anormlies within your application.

INLINE LOAD also is used if data should be typed within the script, and not loaded from a file.

Data entered through an inline clause must be enclosed by quotation marks 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.

Can I suggest you play with INLINE LOAD goto insert tab> Load Statement> Inline Load.

Let me know if this is helpful or has answered your question.

Regards,

Gabriel.

Re: Inline table

prasadreddy — Fri, 08 Mar 2013 12:12:36 GMT

Yes, i want to know, why we use inline with load statement? how it interprets?

Re: Inline table

sushil353 — Fri, 08 Mar 2013 12:13:35 GMT

inline is used if data should be typed within the script, and not loaded from a file

Re: Inline table

nirav_bhimani — Fri, 08 Mar 2013 12:13:40 GMT

HI,

Refer to following post, Hope it will help you.

http://community.qlik.com/message/80405#80405

Regards,

Nirav Bhimani

Re: Inline table

Wed, 26 Jun 2013 06:57:39 GMT

Can anyone tell me where the syntax of the inline statement is explained in detail?

Re: Inline table

narender123 — Wed, 26 Jun 2013 07:16:12 GMT

Hi,

Its quite simple .

Suppose you want to create a table yourself in script without using database.

Then you can do this with inline table

Table:

Load * inline

[

Month,Quarter

1,Q1

2,Q1

3,Q1

4,Q2

5,Q2

6,Q2

7,Q3

8,Q3

9,Q3

10,Q4

11,Q4

12,Q4

];

In this table you will get the 2 dimention

1)Month

2)Quarter

and these dimention heaving value as i type below Month and Quarter.

So you can create a demo qvw with this inline script for better understand.

Thanks

Narender

Re: Inline table

Wed, 26 Jun 2013 07:24:41 GMT

The load statement loads field from a typed ASCII file, from data defined in the script.

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.

It is a scripting base table,which is manually created.

Regards-Biak

Re: Inline table

engishfaque — Fri, 11 Jul 2014 05:10:04 GMT

Dear Prasad,

To the point,

Load Inline:

Load inline can be used for adding data in existing tables or for reading new tables into the document.

In some cases, you may want to add data by entering it directly in QlikView rather than loading it from a file or a database.

Example:

Load * Inline [

Customer_ID, Customer, Address, City, Zip, Country

1101, Catering Service, Fisherman Drive

1102, Portsmouth, BH 354 RW, Great Britain

];

The first line (Customer_ID,Customer, Address, City, Zip, Country) lists the field names

The second line and third line (1101, Alexander's Catering Service, Fisherman's Drive 4, 1102, Portsmouth, BH 354 RW, Great Britain) contains the records that is to be added.

The star symbol * is equival ent to "all fiel ds", which means that the statement should load all of the fields of the new record.

Kind regards,

Ishfaque Ahmed

Re: Inline table

its_anandrjs — Fri, 11 Jul 2014 05:18:19 GMT

Hi,

There are many uses of inline table

1. If you want to load mapping table with two fields you can use inline load.

2. If required introduce some small data in the application.

3. Where necessary introduce some more rows to the existing table you are able to add the data, Suppose you have 50 rows data and you want to test the model with some other rows then that are not in raw data then you just add that rows to the table.

Ex:-

Load * Inline [

Country, Sales

Germany,15852

France,125693

];

4.If required load the table which is based on the variables.

Hope this helps

Re: Inline table

Mon, 23 Feb 2015 16:15:00 GMT

Hello,

I also have a question. How do you load inline numbers with decimal point ? In France, the decimal point is also a comma...

Thanks !

Re: Inline table

linusblomberg — Mon, 23 Feb 2015 16:24:15 GMT

Enter it as a point. Output format is specified in the autogenerated variables on the first tab of your loadscript. Your can also change under properties>number for a certain object.

Re: Inline table

Mon, 23 Feb 2015 16:43:28 GMT

It works, thanks !!

Re: Inline table

erivera10 — Fri, 22 Jan 2016 22:40:08 GMT

It is similar to a csv file, it is separated by commas.

name:

Load * Inline [

Id, field1, field2

1 name1, lastname1

2 name1, lastname1

];

Or can try

Inline Data Wizard

The Inline Data Wizard dialog is opened from the Insert, Judgment Load, Load Inline menu. It serves to create load inline statements in the script.

The dialog contains something very similar to a spreadsheet and in fact works like one in most respects. Note however that the calculated formulas are not evaluated in this spreadsheet as they would eg in Microsoft Excel.

Each column represents a field that can be loaded into QlikView by an inline table. Each row is a record of the table. A data cell by clicking on it is selected. You can then enter a value, by typing or pasting from the clipboard. Press Enter or an arrow key to accept the value and move to another cell.

The top row (label) is reserved for field labels. Double-click a cell to edit label. If no value is entered the field names used F1, F2, etc.

Edit Menu

The Edit menu contains some basic editing commands.

Insert Column Inserts a new blank column if one or more columns.

Delete Column Deletes (s) column (s) selected (s).

Insert Row Inserts a new blank row if one or more rows SELECTED.

Delete Row Deletes the selected row.

Tools menu

The Tools menu contains the Data Document command that opens the Document Data Wizard from which you can paste field values from any field in the document. In this dialog you can see how many field values are in a selected field. Might also choose to insert all values, the values selected or excluded values in the inline wizard.

Click OK to close the dialog and generate a load inline statement reflecting the contents of the grid of the table of dialogue.

http://help.qlik.com/es-ES/qlikview/12.0/Subsystems/Client/Content/Inline_Data_Wizard.htm?q=Inline

Best regards,

Erivera10‌