Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
amit_saini
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