topic Re: Advanced data reduction in section access in QlikView

Advanced data reduction in section access

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have read the pdf guide "Introduction to section access v1.1. It is a good introduction, but do not answer to more advanced needs.

let say I have a table with geographical data : country, post code, city, containing thousand of different data.

I would like to parameter users according to those geographical data. I do not see how I can implement those restrictions :

- a user who can see FR, all postcode starting by 75 and 92. How do you deal with the restriction "starting by" ?

- a user who can see all UK and only city PARIS for FR. If I set a restriction on city = PARIS, it overrides the UK cities.

- a user who can see all FR, except PARIS and LYON. How do I implement a "except" restriction ?

Do you have any idea on how to implement this kind of data reduction ?

Thanks in advance for your help !

Re: Advanced data reduction in section access

Clever_Anjos — Fri, 06 Sep 2013 14:13:57 GMT

- a user who can see FR, all postcode starting by 75 and 92. How do you deal with the restriction "starting by" ?

Create another field using LEFT(yourfield,2)

- a user who can see all UK and only city PARIS for FR. If I set a restriction on city = PARIS, it overrides the UK cities.

Two lines into your Section Access solve this

- a user who can see all FR, except PARIS and LYON. How do I implement a "except" restriction ?

I don´t know how to do this either

Re: Advanced data reduction in section access

Fri, 06 Sep 2013 14:18:30 GMT

You can follow the below link

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

Re: Advanced data reduction in section access

Mon, 09 Sep 2013 07:36:31 GMT

Hello Clever,

thanks for your answers, but they don't answer to the questions.

On first point, the LEFT(postcode, 2) works for french postcode which are meanful on the first 2 digits, but not for UK for eg which is meanfull on the first 3 digits. My question is more generally : can I create restrictions with wildcard caracters (for eg on a customer field, make a security restriction '*SAMSUNG*') ?

On the second point, I suppose your proposition of 2 lines in Section Access looks like :

line 1 : COUNTRY = UK, CITY = BLANK

line 2 : COUNTRY = FR, CITY = PARIS

The result of this restriction is COUNTRY = UK, FR and CITY = PARIS

So, I would only see PARIS, and none of the UK cities, while my need would be to see all UK cities + Paris.

More generally, on the second point, my question is : is it possible to perform restrictions with the OR operator between the lines, instead of AND.

In the above example, the restriction do not work because the restriction makes an AND for the 2 lines of restriction : (COUNTRY = UK) AND (COUNTRY = FR AND CITY = PARIS).

While my need is to get the result with an OR operator : (COUNTRY = UK) OR (COUNTRY = FR AND CITY = PARIS)

Re: Advanced data reduction in section access

Mon, 09 Sep 2013 07:41:23 GMT

Hello Nandkishor

your link can be an answer for my second question, thanks ! By the way, it looks quite complex for a 'simple need'.