Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Island


Hi,

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

5 Replies
Not applicable
Author

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

tresesco
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.

Anonymous
Not applicable
Author

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

arulsettu
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...

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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