QlikView App Dev

[madhubabum]

Hi All,

I am providing security with Section access to my application.

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

Access	NTNAME	Region Code
USER	PRDQLIKSVR\EAST	010101
USER	PRDQLIKSVR\WEST	01*
USER	PRDQLIKSVR\NORTH	05*
USER	PRDQLIKSVR\WEST	020201

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...?

[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;