topic Re: Data Island in QlikView

Data Island

Fri, 24 Jan 2014 07:01:02 GMT

Hi,

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

Re: Data Island

Fri, 24 Jan 2014 07:12:48 GMT

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

Re: Data Island

tresB — Fri, 24 Jan 2014 07:14:03 GMT

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.

Re: Data Island

Anonymous — Fri, 24 Jan 2014 07:27:13 GMT

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

Re: Data Island

arulsettu — Fri, 24 Jan 2014 08:54:03 GMT

HI please refer this link

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

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

Re: Data Island

Peter_Cammaert — Mon, 27 Jan 2014 13:00:36 GMT

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