Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
chitemerere
Valued Contributor

Section Access and Multi Box value display based on user profile (Group)

i have the following  Section Access load:

Section Access;
Directory;
LOAD ACCESS,
USERID,
PASSWORD,
RETAILPHARMACY,
OMIT,
 
NTNAME,
PATENTS,
FDA,
GENERICS,
SHOPPING,
PLAZA_ANALYTICS,
VIEWGROUP
FROM
[..\Data Files\SectionAccess.xlsx]
(
ooxml, embedded labels, table is SectionAccess);

SECTION Application;

VIEWGROUP:
LOAD VIEWGROUP,
_View
FROM
[..\Data Files\MenuViewGroup.xlsx]
(
ooxml, embedded labels, table is ViewGroup);

and the tables are as follows:

SectionAccess table

Screen Shot 2015-12-21 at 17.12.44.png

ViewGroup TABLE

Screen Shot 2015-12-21 at 17.14.25.png

The application is only allowing the ADMIN ACCESS to the application with all users being denied access to the document.  What could be wrong with the the structure of the Section Access above?


The _View field is meant to associate with another field _View which has the following load script:

SET HidePrefix = '_';
View:
LOAD * Inline [
_View
Dashboard
Point in Time Reporting
Leading Therapeutic Classes (Level 1)
Leading Therapeutic Classes (Level 3)
Leading Companies
Leading Products
Leading New Products
Payment Method Summary
Co-payment Summary
Fastest Growing Therapeutic Classes (ATC3)
Comparative Analysis
Trend Analysis
Product Analytics
Generic Products Opportunity Analysis
Patent Analytics
FDA Analytics
Shopping Analytics
Pharmacy Analytics
]
;

The above values are then loaded into a multi box with the following results.

Screen Shot 2015-12-21 at 17.02.57.png

I would want an expression to dynamically change what is listed in the multi box based on the USER profile or VIEWGROUP.  How can this be accomplished?


Regards.

1 Solution

Accepted Solutions
chitemerere
Valued Contributor

Re: Section Access and Multi Box value display based on user profile (Group)

With Section Acces, the problem was the lower case in the field _View. Re-did as follows;

VIEWGROUP:
LOAD VIEWGROUP,
Upper(_View) as _VIEW
FROM
[..\Data Files\MenuViewGroup.xlsx]
(
ooxml, embedded labels, table is ViewGroup);

and the tables are as follows:

View solution in original post

2 Replies
chitemerere
Valued Contributor

Re: Section Access and Multi Box value display based on user profile (Group)

Dear All

I managed to sort out the second portion of my problem.  I  used the following expression to change multi box display based on user ViewGroup:

  =If(VIEWGROUP = 'VIEWALL' , _View, if(VIEWGROUP = 'BASICSHOPPLAZA', If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis'), _View), If(VIEWGROUP = 'BASIC',If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis', 'Pharmacy Analytics', 'Shopping Analytics'), _View), If(VIEWGROUP = 'BASICSHOPMEDIX',If(Not Match(_View, 'Patent Analytics', 'FDA Analytics', 'Generic Products Opportunity Analysis', 'Pharmacy Analytics'), _View)))))


Document still locked out for all users despite a first success open after reloading the first time.  On trying the second time, it fails to open for all users except admin.

Regards

chitemerere
Valued Contributor

Re: Section Access and Multi Box value display based on user profile (Group)

With Section Acces, the problem was the lower case in the field _View. Re-did as follows;

VIEWGROUP:
LOAD VIEWGROUP,
Upper(_View) as _VIEW
FROM
[..\Data Files\MenuViewGroup.xlsx]
(
ooxml, embedded labels, table is ViewGroup);

and the tables are as follows:

View solution in original post