Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dilip_solanki
Contributor

Getting [circular] warning while reloading data

Hi All,

I am getting one warning because of that my Qlik objects are getting impacted.

I have following tables:

Geo:

LOAD

     GeoDocumentId,

     GeoDocumentDescription,

     GeoName,

     GeographicKey AS GEOKEY;


Zone:

LOAD

     ZoneDocumentId,

     ZoneDocumentDescription,

     ZoneName,

     ZoneKey AS ZoneKEY;

City:

LOAD

     CityDocumentId,

     CityDocumentDescription,

     CityName,

     CityGraphicKey AS CITYKEY;


CMM_Permission:

LOAD

     ACCESS,

     USERID,

     GEOKEY,

     ZONEKEY,

     CITYKEY;

SQL EXECUTE Get_CMM_UserPermissions;



After loading data I am getting following error:

QlikError.PNG

Can anyone suggest that why I am getting this and how to get rid of this?

Thanks

Dilip Solanki

Thanks
Dilip Solanki
5 Replies

Re: Getting [circular] warning while reloading data

Read about this here

Circular References

dilip_solanki
Contributor

Re: Getting [circular] warning while reloading data

Hi Sunny,

Thanks for the answer. I got the cause of circular reference. But I have to give same name to my column in CMM_Permission table, as this table I am using for Section access.

For section access I have to specify column right, to define the reduction column.

Can you suggest me how to resolve this, with section access.

Thanks

Dilip Solanki

Thanks
Dilip Solanki

Re: Getting [circular] warning while reloading data

In this script... I don't see any circular reference problem...

Geo:

LOAD

     GeoDocumentId,

     GeoDocumentDescription,

     GeoName,

     GeographicKey AS GEOKEY;


Zone:

LOAD

     ZoneDocumentId,

     ZoneDocumentDescription,

     ZoneName,

     ZoneKey AS ZoneKEY;

City:

LOAD

     CityDocumentId,

     CityDocumentDescription,

     CityName,

     CityGraphicKey AS CITYKEY;


CMM_Permission:

LOAD

     ACCESS,

     USERID,

     GEOKEY,

     ZONEKEY,

     CITYKEY;

SQL EXECUTE Get_CMM_UserPermissions;

Is this the complete script? or are you accidentally running more script then this?

dilip_solanki
Contributor

Re: Getting [circular] warning while reloading data

Yes this is complete script. I do not have any other script. I have only these 4 tables Geo, Zone, City and CMM_Permission.

Thanks
Dilip Solanki

Re: Getting [circular] warning while reloading data

Can you post an image of your data model after the reload?

Community Browser