Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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)