Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
dilip1234
Creator
Creator

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
sunny_talwar

Read about this here

Circular References

dilip1234
Creator
Creator
Author

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
sunny_talwar

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?

dilip1234
Creator
Creator
Author

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
sunny_talwar

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