Thursday, March 7, 2013

Inline Syntax

http://qlikviewdev.blogspot.com/2013/01/inline-table.html

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.

2 comments:

  1. 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!
    Data 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

    ReplyDelete