Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sarathi_pm
Contributor II
Contributor II

Section Access to view the total sum of data and only specific user related data

Hello Guys,

I am stuck up with a logic in implementing section access in Qlikview.

Below is my data

NameMarksSubject

John

80Maths
Pete40Physics

Max

60Chemistry
George40Chemistry
Tracy50Maths
Becky60Maths
Harry90Physics

when one of the above users (Name) login to the dashboard they should be able to see the total average marks (Sum of Marks /Total number of Users = 440/7 = 63) and only their marks.

Below is what I am looking for is a simple bar chart with a dot. The bar shows the average marks and the dot shows the mark of the logged in person.

                 o

Blue Bar - Total Average Marks of all Students

White Circle- Mark of the logged in person

Any idea how to achieve this using section access.

Below is my code - But it shows only the logged in person's mark and not the total average of all the users

Data:

Load

Name as Student_Name,

Marks,

Subject

from.....

 

SECTION Access;
LOAD ACCESS,
     
NTNAME
FROM
[Data\User Access\User Access.xlsx]
(
ooxml, embedded labels, table is Sheet1);

SECTION Application;

AccessTable:
LOAD 
     
NTNAME,
     
[Name] as Student_Name
FROM
[Data\User Access\User Access.xlsx]
(
ooxml, embedded labels, table is Sheet2);

Thanks

Sarathi

 

3 Replies
bramkn
Partner - Specialist
Partner - Specialist

I think what you need to do is seperate the total from the normal data. so create a table with just the total for example. or add a column that shows the total/avg on every row.

sarathi_pm
Contributor II
Contributor II
Author

Hello Bram,

Thanks for looking into this and giving your response.

However the dataset I have has lot of other calculations because of which I cant go with the approach you have mentioned. Is there any other way around?

I may need to show many other mean, min and max from the overall data and show where the logged in user value lies.

Thanks

Sarathi

Venkatchoudary
Contributor III
Contributor III

I think you better show  total  marks average in separate KPI and
Provide Section Access by Chart Level or Column/Field level.