Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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