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

[sarathi_pm]

Hello Guys,

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

Below is my data

Name	Marks	Subject
John	80	Maths
Pete	40	Physics
Max	60	Chemistry
George	40	Chemistry
Tracy	50	Maths
Becky	60	Maths
Harry	90	Physics

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

[bramkn]

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]

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]

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