topic Re: Full Company vs Division When Section Access is Applied in QlikView

Full Company vs Division When Section Access is Applied

aveeeeeee7en — Tue, 08 Jul 2014 05:49:39 GMT

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???

Regards

Aviral Nag

Re: Full Company vs Division When Section Access is Applied

Tue, 08 Jul 2014 05:53:07 GMT

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.

Re: Full Company vs Division When Section Access is Applied

SunilChauhan — Tue, 08 Jul 2014 05:58:55 GMT

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

Re: Full Company vs Division When Section Access is Applied

aveeeeeee7en — Tue, 08 Jul 2014 06:17:57 GMT

Any Suggestions????

Re: Full Company vs Division When Section Access is Applied

tresB — Tue, 08 Jul 2014 06:22:55 GMT

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

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

aveeeeeee7en — Tue, 08 Jul 2014 06:52:06 GMT

Tresesco Sir thanks for the reply.

PFA.

Re: Full Company vs Division When Section Access is Applied

tresB — Tue, 08 Jul 2014 07:18:22 GMT

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.

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

aveeeeeee7en — Tue, 08 Jul 2014 07:19:42 GMT

After assigning Section Access I am facing this Problem:

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

aveeeeeee7en — Tue, 08 Jul 2014 07:43:45 GMT

Not able to achieve the desired result.

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

tresB — Tue, 08 Jul 2014 07:58:16 GMT

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.

Re: Full Company vs Division When Section Access is Applied

aveeeeeee7en — Tue, 08 Jul 2014 10:37:04 GMT

Thank You Sir.

It works.