Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
madhubabum
Creator
Creator

Security issue using Section Access .

Hi All,

I am providing security with Section access to my application.

While implementing security, we are using excel file as following.

   

AccessNTNAMERegion Code
USERPRDQLIKSVR\EAST010101
USERPRDQLIKSVR\WEST01*
USERPRDQLIKSVR\NORTH05*
USERPRDQLIKSVR\WEST020201

In My section access file, i want read * (because i am also having sub region codes for WEST,NORTH)

Remaining working perfectly, But i want to read sub region codes also while implementing security(With EXCEL).

Note : If i am having 010101,010102,010103,0101..............99.Having like this.

If I logged into WEST , i want to show all the region codes(From 010101 to 010199)

How we can achieve this...?

1 Reply
Anil_Babu_Samineni

With in the Field row values it consider as Cell not the Wildcard match. can you try this way?

Section Access;

Load Access, NTNAME, If(WildMatch([Region Code], '01*', '05*'), [Region Code]) as [Region Code] Inline [

Access,    NTNAME,    Region Code

USER,    PRDQLIKSVR\EAST,    010101

USER,    PRDQLIKSVR\WEST,    01*

USER,    PRDQLIKSVR\NORTH,    05*

USER,    PRDQLIKSVR\WEST,    020201

];

Security Application;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)