Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Full Company vs Division When Section Access is Applied

Dear Community

I have a requirement to show Full Company vs Division Gender Bifurcation.

The problem I am facing is I have assigned Section Access on the Division field for some of users.

When a person opens Application, he only sees his Division Data, so how this is possible to show full company Data.

Is the below requirement possible when Section Access is Applied.  Need Suggestions???

Requirement.png

Regards

Aviral Nag

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Re: Re: Full Company vs Division When Section Access is Applied

Section Access;
Load * inline
[ACCESS,USERID,PASSWORD, DIVISION
ADMIN, Admin,Admin,
USER,AAAA,aaaa, AAAA
USER, BBBB, bbbb, BBBBB ];
Section Application;

LOAD Sex&EmpStatus,
  EmpCode,
    Sex,
    EmpStatus,
    DIVISION
FROM
TestFile.qvd
(qvd);

LOAD Sex&EmpStatus,
  Count(DISTINCT EmpCode) as AggrCount
   
FROM TestFile.qvd (qvd) Group By Sex, EmpStatus;

PFA. Changed the expression of the first chart.

View solution in original post

10 Replies
Highlighted
Not applicable

Re: Full Company vs Division When Section Access is Applied

i have done a similar thing. Not sure if that is the best way. I had duplicate columns for all the measures in a different table which would not have the division name at all. so when you actually reduce the data this duplicate table won't reduce and you get the entire view of the data but with different column names. Then you use that data for comparison. Not an easy task i should tell you upfront.

This is primarily used for benchmarking and was worth the pain, Users simply loved to see how their division fares in overall scheme of things.

Highlighted
Champion
Champion

Re: Full Company vs Division When Section Access is Applied

i thing you can provide hime all divisions access then he will have all company data.

as company data is link to Division.

if you provide 1 region then data related to that region will be visible. and full then full data

Highlighted
Specialist III
Specialist III

Re: Full Company vs Division When Section Access is Applied

Any Suggestions????

Highlighted
MVP
MVP

Re: Full Company vs Division When Section Access is Applied

If you aggregate the data in the script, you could achieve that. For detailed help, provide a sample.

Highlighted
Specialist III
Specialist III

Re: Re: Full Company vs Division When Section Access is Applied

Tresesco Sir  thanks for the reply.

PFA.

Highlighted
MVP
MVP

Re: Full Company vs Division When Section Access is Applied

LOAD
          EmpCode,
         Sexx,          // renamed to avoid moderation delay
         EmpStatus,
         DIVISION
FROM
TestFile.qvd
(qvd);

LOAD  Sexx,
            Count( EmpCode) as AggrCount    
FROM TestFile.qvd (qvd) Group By Sexx;

Note: Use AggrCount field in the expression for referering  total count.

Aggreagate the count on sexx dimension like above and apply the section access thereafter, divisions would get the total even after that.

Highlighted
Specialist III
Specialist III

Re: Re: Full Company vs Division When Section Access is Applied

After assigning Section Access I am facing this Problem:Problem.png


Highlighted
Specialist III
Specialist III

Re: Re: Full Company vs Division When Section Access is Applied

Not able to achieve the desired result.

Highlighted
MVP
MVP

Re: Re: Re: Full Company vs Division When Section Access is Applied

Section Access;
Load * inline
[ACCESS,USERID,PASSWORD, DIVISION
ADMIN, Admin,Admin,
USER,AAAA,aaaa, AAAA
USER, BBBB, bbbb, BBBBB ];
Section Application;

LOAD Sex&EmpStatus,
  EmpCode,
    Sex,
    EmpStatus,
    DIVISION
FROM
TestFile.qvd
(qvd);

LOAD Sex&EmpStatus,
  Count(DISTINCT EmpCode) as AggrCount
   
FROM TestFile.qvd (qvd) Group By Sex, EmpStatus;

PFA. Changed the expression of the first chart.

View solution in original post