Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ebrahimaljefri
New Contributor III

Inline Load in Qliksense

hi,

i am using qlik sense Desktop and what i have understand of Inline Load in Qliksense that its considered as temporary that is created within script  . i am wondering that can i add more dimensions in the Inline Load ?

11 Replies
datanibbler
Esteemed Contributor

Re: Inline Load in Qliksense

Hi,

I have no experience in QlikSense, only in QlikView - but isn't there a wizard for Inline_tables? In QlikView there is and you can add as many columns as you want.

arvind_patil
Valued Contributor III

Re: Inline Load in Qliksense

Hi ibrahibra,

You can add multiple dimension in inline table.

Like This:

Table:

LOAD * Inline [

ID  , brand , criteria        ,    assesement

123 , abc ,   Q9,                   Y

145 , abc ,   Q9,                   Y

123 , abc ,   P11,                  Y

145 , abc ,   P11,                  N

];

Thanks,

Arvind Patil

balabhaskarqlik
Honored Contributor

Re: Inline Load in Qliksense

Yes you can add more dimensions.

ebrahimaljefri
New Contributor III

Re: Inline Load in Qliksense

dimensions from different table ?

using resident ()

rittermd
Honored Contributor

Re: Inline Load in Qliksense

An Inline table is a manual load of data that you type in the script.  It can be very useful depending on your situation.

If you are trying to load real data from tables then you would not use this method.  You would load from the tables and join or whatever you need to do.

If you want the inline table to interact with another table then you need to make sure that the field names in each match so that QS associates them.

dberkesacn
Contributor III

Re: Inline Load in Qliksense

Hi it is totally the same as it is in QlikView, the only difference is there is no wizard.

LOAD * INLINE [

    Dim1, Dim2, Value

    A, A01, 100

    B, B01, 40

    B, B02, 60

];

ebrahimaljefri
New Contributor III

Re: Inline Load in Qliksense

so i can use inline to create a table that could have many to many relationship in my script !

dberkesacn
Contributor III

Re: Inline Load in Qliksense

Yes, you can make data tables there is no restriction regarding: rows number (dim, measure), and tables number, but the data will be hard coded.

beck_bakytbek
Honored Contributor

Re: Inline Load in Qliksense

Hi Ibrahibra,

check this, that helps you to understand this issue much better:

https://www.youtube.com/watch?v=-iCAgay3Z4c

i hope that helps

Beck