Inline table

[prasadreddy]

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

[sushil353]

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

[prasadreddy]

Hi sushil, thanx for reply,

but still i am not understanding 'Load Inline'

[#4]

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

[Gabriel]

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.

[prasadreddy]

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

[sushil353]

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

[nirav_bhimani]

HI,

Refer to following post, Hope it will help you.

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

Regards,

Nirav Bhimani

[#9]

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

[narender123]

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