Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
I think you better show total marks average in separate KPI and
Provide Section Access by Chart Level or Column/Field level.