Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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
Yes you can add more dimensions.
dimensions from different table ?
using resident ()
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.
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
];
so i can use inline to create a table that could have many to many relationship in my script !
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.
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