Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Champion
Champion

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.

Highlighted
Partner
Partner

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

Highlighted

Yes you can add more dimensions.

Highlighted
Contributor III
Contributor III

dimensions from different table ?

using resident ()

Highlighted
Master
Master

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.

Highlighted
Partner
Partner

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

];

Highlighted
Contributor III
Contributor III

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

Highlighted
Partner
Partner

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.

Highlighted
Master
Master

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