Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Section Access - for all values(Not Just *)

Hi

I have 10 products named A,B,C,D,E,F,G,H,I,J

Using section acees I want to enable:

[ Reduction of Products ]

U1 to access A,B products

U2 to access B,C products

U3 to access all the products. products

How can I achieve it ?

1 Reply
Highlighted
Master III
Master III

Hi

First maintain an excel sheet. (See the attchment) after this write this script in your qvw :

Section Access;

Access:

LOAD ACCESS,

    NTNAME,

    upper(Product) as Product

FROM

[Give the path of excel sheet\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table is SectionAcess)

where 1=1;

Section Application;

PlantAccess:

load

    upper(Product) as Product,

    Product asProduct

FROM

[Give the path of excel sheet\Section_Application_Plant.xlsx]

(ooxml, embedded labels, table isSectionAcess)

where 1=1;

Thanks,

AS