Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist
Specialist

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
qlikviewnovice
Specialist II
Specialist II

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
Specialist
Specialist
Author

Hey,

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

qlikviewnovice
Specialist II
Specialist II

Yes, You are correct!!

qlikviewnovice
Specialist II
Specialist II

tresesco
MVP
MVP

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

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

Peter_Cammaert
Partner
Partner

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
Specialist II
Specialist II

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
Specialist III
Specialist III

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