Discussion Board for collaboration related to QlikView App Development.
I am providing security with Section access to my application.
While implementing security, we are using excel file as following.
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...?
With in the Field row values it consider as Cell not the Wildcard match. can you try this way?
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