Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mikehannig_
Contributor III
Contributor III

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
Partner

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