topic Profiling data and global access to associative schema in QlikView

Profiling data and global access to associative schema

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I need to profile data by user (for which I could use Section Access) but at the same time I need to show user information that are retrieved by formula that need to works on the overall data.

For example I need to show to a user his revenue against the country revenue.

If I use Section Access I can't evaluate country revenue.
Use Data Island could be difficult because I have a lot of KPI's that are going to work in this way.

What do you suggest?

Thanks a lot

Re: Profiling data and global access to associative schema

Gysbert_Wassenaar — Mon, 29 Feb 2016 17:00:10 GMT

I don't understand why you think you need Section Access for data profiling. Section Access is used for access to the document and access to data in a document. Data profiling as I know it (Data profiling - Wikipedia, the free encyclopedia‌‌) has little to do with organizing access to date.

Re: Profiling data and global access to associative schema

Colin-Albert — Mon, 29 Feb 2016 17:06:17 GMT

You may need to load the data twice.

One set that details the user, and would be restricted by Section Access, and a second set of data that does not identify the user, but is summarised by country.

This would allow all users to analyse by country without the ability to get to a user level of granularity.