The Inline is a interesting concept in QlikView. This will be useful when the data is static and it will avoid a database hit .
Syntax:
load [ distinct ] *fieldlist
[( from file [ format-spec ] |
from_fieldfield [format-spec]
inline data [ format-spec ] ]
[ where criterion ] | while criterion ]
[ group_by fieldlist ]
[order_by field [ sortorder ] { , field [ sortorder ] } ]
Example:
We all know the budgeting system has only three accounting types (Actual, Budget and Projection) for analysing the data. So if we want to show it in the dropdown select or list box we can hard code it using the Inline table.
Inline:
Load * Inline [Account_Type
Actual,
Budget,
Projection];
Output:
Table: Inline |
Account_Type |
Actual
|
Budget
|
Projection
|
As the data is already known and static this Inline function saves a database hit.
magnificent publish, very informative. I wonder why the other specialists of this sector don’t notice this. You should continue your writing. I’m confident, you’ve a great readers’ base already!
ReplyDeleteData Modeling Process in qlikview
•Star Schema Design – Thinking
–Identify the fact tables and the look up tables
•Is SQL the only technology for reporting?
–In-Memory Analytics – thinking habits need to change
•Handling Fact Tables
–Start with one fact table –Add Multiple FACT TABLES with•Keys•Concatenate / Join•Link Tables –Incremental Load.
thanks.qlikview training in hyderabad
tuzla bosch klima servisi
ReplyDeletetuzla arçelik klima servisi
çekmeköy samsung klima servisi
ataşehir samsung klima servisi
çekmeköy mitsubishi klima servisi
maltepe vestel klima servisi
kadıköy vestel klima servisi
maltepe bosch klima servisi
kadıköy bosch klima servisi