topic Re: Section access OMIT Particular Location in QlikView

Section access OMIT Particular Location

sunilkumarqv — Wed, 01 Jul 2015 04:30:15 GMT

Hi Friends ,

Section access working fine in my app but how can omit particular CITY

for exm:

ACCES,USERID,PASSWORD,CITY

ADMIN,ADMIN,AMIN123, *

USER,USER, a@mil.com, OR

USER,USER1 ,b@mil.com, WA

USER,USER2 ,c@mil.com, ON

USER,USER3,d@mil.com,OR ---------OMIT only OR

USER,USER4 ,e@mil.com, MN

USER,USER5,f@mil.com, *

for USER3 can authorize to see all city's except OR

tresB — Wed, 01 Jul 2015 04:43:36 GMT

You have to include several rows against the same user listing all cities except OR. May be like:

USER,USER3,d@mil.com,CITY1

USER,USER3,d@mil.com,CITY2

...

USER,USER3,d@mil.com,CITYn

It's not very graceful way, i know, but this is how it has to be like.

However, there is another way to it which is again a bit complex; creating generic keys. You may refer :Re: Section access - exclude just one value!