Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadreddy
Contributor III
Contributor III

Inline table

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

16 Replies
sushil353
Master II
Master II

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
Contributor III
Contributor III
Author

Hi sushil, thanx for reply,

but still i am not understanding 'Load Inline'

Not applicable

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
Partner - Specialist III
Partner - Specialist III

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
Contributor III
Contributor III
Author

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

sushil353
Master II
Master II

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

nirav_bhimani
Partner - Specialist
Partner - Specialist

HI,

Refer to following post, Hope it will help you.

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

Regards,

Nirav Bhimani

Not applicable

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

narender123
Specialist
Specialist

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