Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

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

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

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

Specialist
Specialist

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