Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get total of all data (without restriction) in section access

I have section access for every user in my QVW

for example:

user 1 --> has access for all data in Regional 1

user 2 --> has access for all data in Regional 2

user 3 --> has access for all data in Regional 3

the problem is every user needs to see the total value of all region (region 1 + region 2 + region 3)

how can I achieve this?

Thank you

2 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Mike,

I think you need to calculate total value in region

user 1 --> has access for all data in Regional 1,Total

user 2 --> has access for all data in Regional 2,Total

user 3 --> has access for all data in Regional 3,Total

User All-->has access for all data in Regional Total



And Give access For All


Thanks,

Arvind patil

rahulpawarb
Specialist III
Specialist III

Hello Mike,

As a workaround, you can load a summary table in QlikView containing Total Value by Region. This will help you to show detailed records for Region specific to user and summary values for all Regions.

Hope this will help.

Regards!

Rahul Pawar