Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Automating Complex Section Access

Hi,

I am trying to automate the Complex Section Access logic mentioned in the below link  https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization?_ga=1.182749103...

We would like to get this in a auto-pilot mode where users can enter as many section access columns of their liking. (e.g. 2 as in the below example or 3 columns (e.g. State, Product, Employee)).

StateProduct
New YorkJackets
New YorkBoots
CaliforniaAccessories

In the Qlikview Script

1. We concatenate the column in the Fact table to generate the AuthID column

2. Create the Bridge Table with AuthID and %AuthID

I was able to get the 1st part working (the easier one ). Unable to think of a logic to get the 2 part. I am unable to think of a logic to replace one or more column with * to generate the %AuthID column.

Thanks,

Vignesh

Community Browser