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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mMelia
Contributor II
Contributor II

Qlik Sense-Section Access

Hello,

I have big Qlik Sense App with several users. I want to restrict several rows based of users. 
I have field called "Plan_Version". I need some users to see every value except when Plan_Version is equal to 'C'.

I was thinking of doing this by  Section Access but I couldn't find a way to omit only one value from field. 

Any help would be appreciated. 
Thank you in advance. 


Labels (1)
2 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

You can try creating one more column to identify the records of 'C' and 'Rest all'.

Example, If(Plan_Version = 'C', 'Plan_Version_C' , 'Plan_Version_All') as PLAN_VERSION_NEW

Apply section access on new field PLAN_VERSION_NEW, where you can give access to value 'Plan_Version_All', so the 'C' values will be excluded.

Hope this helps.

Thanks,

Ashutosh

anat
Master
Master