Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ebrahimaljefri
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
datanibbler
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.

arvind_patil
Partner - Specialist III
Partner - Specialist III

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

Yes you can add more dimensions.

ebrahimaljefri
Contributor III
Contributor III
Author

dimensions from different table ?

using resident ()

rittermd
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.

dberkesacn
Partner - Creator III
Partner - Creator III

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

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

dberkesacn
Partner - Creator III
Partner - Creator III

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
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