Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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



1 Solution

Accepted Solutions
tresesco
MVP
MVP

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
tresesco
MVP
MVP

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!