Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Data Island


Hi,

Can anyone Please explain what is a data Island,How and when they are used?

5 Replies
Highlighted
Not applicable

Hi,

As per my knowledge, data island are those table in data model which are not linked to any other table.

For eg, if you have a inline table which is not linked to our data table then that inline table is data island.


HTH

-Shruti

Highlighted
MVP
MVP

Data island is nothing but a associated group of tables. Say your data model has 10 tables, out of which 7 are interconnected to form a group1 and three are interconnected to form group2; group1 and group2 are nowhere linked. In such circustances, it would be said that your data model has two data islands  group1 and group2.

Highlighted
Specialist
Specialist

A Data Island is Data which you design and keep and use it .

Like say you create a Inline table of Dates

DataIsland:

Load * Inline

[

Inline_Date

2013-01-01

2013-04-01

];

and you have a sales transaction table which has Sales_Trans_Date, Sales_Amount , sales_quantity ,

even thou you have date field in transaction tables but still you want to calculate keeping some other

particular date in mind so you create and use a Data Island for this with dates you desire

so like if you want to calculate sum of quantity before 2013-04-01  you use your DataIsland table date

instead of transaction table dates  sum({< Date={ '<=$(max(inline_Date)'} >} Sales_quantity)

anant

Highlighted
Master III
Master III

HI please refer this link

Qlikview: Data Island using concat() function | Hyunku's Blog

they explained here in detail i hope it helps...

Another use of a date island is when you want to dynamically configure interfaces, for instance the type and number of expressions shown in a (pivot/straight) table.

Start with the definition of an INLINE table containing expression names, like:

Expressions:

LOAD * INLINE [

ExpressionName

Revenue

Volume

Cost (Tot)

Price (Tot)

Price/Volume

Cost/Unit

];

Display this field on screen as a list box. Initially everything will be white.

Add a corresponding expression to your table, but make every expression conditional based on the selection in the 'ExpressionName' field. The Conditional Show for expression 'Revenue' can look like:

SubstringCount(GetFieldSelections(ExpressionName, ',', 20), 'Revenue') > 0

This expression will check whether 'Revenue' has been selected (green) in the list box and enable the expression column if so. Note that there is no direct connection between table Expressions and anything else in this data model.

Best,

Peter