Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
sunilkumarqv
Specialist II
Specialist II

Section access OMIT Particular Location

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

USER,USER5,f@mil.com,    *


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



Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

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!

View solution in original post

1 Reply
tresB
Champion III
Champion III

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!