Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Make a button appear based on section access

Hi,

I have a button on my Document, I only want this to show when the user has access to all data? The field that determines what access a user has is called "Permission" there are two values in this field which are called 'Secure' or 'NonSecure'. So if a user has access to see all the data he would see both sets. I tried to do something with the button on the Layout tab and do a conditional formula on the "Show" option but not sure what to do? I've tried the following =Permisson =('*') but to no avail

Thanks

1 Solution

Accepted Solutions
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I would suggest going with the functions maxstring and minstring and section access to ignore all selections.  The show condition could then be:

maxstring({1}Permission) = 'Secure' and minstring({1}Permission) = 'NonSecure'

Hope that helps,

Steve

QlikView Consultant

View solution in original post

5 Replies
Miguel_Angel_Baeyens

Hello Ivan,

If the field is Permission and there's only one possible value per user, the conditional should look like

Permission = 'Secure'

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

ivandrago
Creator II
Creator II
Author

Hi,  Some Users will see data where the Permission is "NonSecure", basically when there is a user who I have said on the Section Access that they can see ALL, I want a button to show on there document.

ivandrago
Creator II
Creator II
Author

Any experts have an idea?

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I would suggest going with the functions maxstring and minstring and section access to ignore all selections.  The show condition could then be:

maxstring({1}Permission) = 'Secure' and minstring({1}Permission) = 'NonSecure'

Hope that helps,

Steve

QlikView Consultant

Miguel_Angel_Baeyens

Hi Ivan,

Try the following as conditional:

=Match('Secure', $(=chr(39) & Concat(DISTINCT Permission, chr(39) & chr(44) & chr(39)) & chr(39)))

That will return greater than zero (so true) in the case that the value "Secure" is in the list of all possible Permission values the user has.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica