Removing data island from Qlik data model

[kishorj1982]

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

[petter]

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.

[kishorj1982]

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

[petter]

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.