topic Re: Removing data island from Qlik data model in QlikView

Removing data island from Qlik data model

kishorj1982 — Mon, 24 Sep 2018 06:12:49 GMT

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

Re: Removing data island from Qlik data model

petter — Mon, 24 Sep 2018 06:20:46 GMT

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.

Re: Removing data island from Qlik data model

kishorj1982 — Mon, 24 Sep 2018 07:18:00 GMT

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

Re: Removing data island from Qlik data model

petter — Mon, 24 Sep 2018 11:46:46 GMT

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.