Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nikhilgarg
Valued Contributor

What are data islands?

Hey,

I have a question about Data Islands.

Data Islands can be created from any data source and are disconnected from other tables in data model.

For ex. in data model let say we have 10 table, out of which 6 tables are interconnected to each other and rest 4 are interconnected to each other. But these group of 6 and 4 tables are not connected to each other. So there are said to be 2 data islands in data model.

Am i correct about data islands?

Thanks

10 Replies
Highlighted
qlikviewnovice
Valued Contributor II

Re: What are data islands?

Data islands

From time to time, you may want to load data that is a separate table, disconnected from any other field in your data model. This is called a data island. Data islands can be created from any data source and are often created as an inline table. Data islands can be used to reference dates, table headers, or whatever you need to be disconnected from most of the existing data in the data model.

One useful example of data islands is to aid in the construction of table charts in the presentation layer of your document, for instance, to allow you to create rows containing measured values rather than dimensions. Let's use a call center example where we track customer representative telephone calls and call times.

nikhilgarg
Valued Contributor

Re: What are data islands?

Hey,

Thanks but i don't get the use of data islands

qlikviewnovice
Valued Contributor II

Re: What are data islands?

Yes, You are correct!!

qlikviewnovice
Valued Contributor II

Re: What are data islands?

MVP
MVP

Re: What are data islands?

What is he correct at? If you mean - there is no such use of data island, sorry, you both are NOT correct.

There would be situations when you would want one segment of your reports to be unresponsive to any selection to a different set of filters, because they are logically unassociated. Then you have to keep the model disconnected resulting an island. Sometimes developers loads some fields that is used to handle trivial issues like setting toggles between views or so; setting unassociated flags...all would result islands and those are useful. I could give many such examples, but I am lazy.

Not applicable

Re: What are data islands?

Some times we need to display the static values which are not relates any other table

Re: What are data islands?

A typical use of date islands is in User Interface-design and Ad-hoc reporting.

Imagine that you have a straight/Pivot table with a large number of interesting expression columns. The table may be too large for most users, and different users may be only interested in different sets of expressions. How do you make the layout of this table configurable?

Create an unconnected INLINE table with a single field containing unique names for all expressions. Present this field as a list box on the sheet of the large table. For every expression, add a Conditional show expression that makes the expression column visible whenever the name of this particular expression is selected in the list box (for practical examples, search the community).

Peter

qlikviewnovice
Valued Contributor II

Re: What are data islands?

Hi,

I have replied to his posted question as Correct not for his statement " there is no such use of data island "

Thank you for sharing about Island Tables

kkkumar82
Valued Contributor III

Re: What are data islands?

Hi ,

Let me explain you with an example, in our project we have a total of 8 bar charts with same expressions but the change is in dimensions.

Initially I created a  a cyclic group with all the dimensions later thought differently and created a data island table with just

Sno, Dimension inline load.


and I created a input box with a variable using concatinated the dimensions values, and used the variable in the dimension of the bar chart.


Hope you have got it.


Thanks

Kiran Kumar