Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Removing data island from Qlik data model

Hi all,

PFA.

Can you please suggest how to remove data island from data model.

Shall we replace them with variable and if so could you please share an example for the same.

Thanks

3 Replies
Highlighted
MVP
MVP

Re: Removing data island from Qlik data model

If the data island tables each contain only one row in one field it would be easy to replace them with a variable for each field. I suspect few if any of them have just a single value or single row though...

From the screenshot you provided it seems that the data islands has been made deliberately. Do you have any idea why?

If you explain what the data island tables contain it might it is easier to suggest a good solution. Also it would be helpful to get to know some of the expressions that involve fields from some of the data islands and their fields.

Highlighted
Contributor II

Re: Removing data island from Qlik data model

Hi Peter,

some Calculations are like below,

Suppose Currency is one data island then there are number of values inside that column like

USD, INR etc. then we used if else statement in expression.

if (Currency='USD', condition 1, condition 2).

May I know how to replace above calculation with variables

Thanks

Highlighted
MVP
MVP

Re: Removing data island from Qlik data model

If the data islands are used to give the user the ability to select like for instance the currency then it is not so easy to replace that with just a variable.