topic Re: Inline in QlikView

Inline

ashokraju — Tue, 01 Aug 2017 12:11:55 GMT

Hi,

If we create inline load then what is the relation between inline table with existing datamodel.

Re: Inline

Chanty4u — Tue, 01 Aug 2017 12:13:53 GMT

you can create a key field with the main table

Re: Inline

Anil_Babu_Samineni — Tue, 01 Aug 2017 12:16:11 GMT

For your question - There is no relation between data model and Island table because these are simple inline tables only. And, If you want to make RDBMS you could use Generation seq key as you need ??

Re: Inline

ashokraju — Tue, 01 Aug 2017 12:25:53 GMT

Hi..

for performance wise inline tables are good or bad..

Some body said inline load create cross join with our datamodel..so it impacts performance..is it correct..

Re: Inline

zhadrakas — Tue, 01 Aug 2017 12:26:20 GMT

you can see that in your Data-Model.

It Could be any relation.

Sample for 1:1

INLINE:
LOAD * INLINE [
Week
21
22
23
];

DATAMODEL:
LOAD * INLINE [
Week, Sales
21, 100
22, 200
23, 250
];

Perfect Key says every record has one unique match. So 1:1 relation

Sample for 1:n

INLINE:
LOAD * INLINE [
Week
21
22
23
];

DATAMODEL:
LOAD * INLINE [
Week, Sales
21, 200
21, 300
22, 223
22, 332
23, 332
23, 999
];

Now it is not a perfect key. Only key. There you can see that this is a 1:n relation.

Sample for m:n

INLINE:
LOAD * INLINE [
Week, Test, Sales
21, A, 200
21, B, 200
22, C, 200
22, E, 200
23, A, 200
23, B, 200
];

DATAMODEL:
LOAD * INLINE [
Week, Sales
21, 200
21, 300
22, 223
22, 332
23, 332
23, 999
];

Now there is an Synthetic Key generated that got rid of the m:n relation.

Hope this helps

Regards

tim

Re: Inline

Kushal_Chawda — Tue, 01 Aug 2017 12:27:44 GMT

If you have created inline table and linked with one of the table in data model, then relationship is associative. If you have created inline table which is not connected to any other table in your data model then there is no relationship between your data model and inline table.In this case, these inline table is called as "Data Island"

Re: Inline

Kushal_Chawda — Tue, 01 Aug 2017 12:34:28 GMT

To answer your question refer to below link

https://qlikviewcookbook.com/category/performance/

Re: Inline

ashokraju — Thu, 03 Aug 2017 09:24:37 GMT

thanku