Hide Calculated Measure

[Bob07]

Hi everyone,

Need help. I have created an app with several fields (dimensions). I also calculated 2 measures (price and costs) on the front end of the app. Now I want to restrict user views to these measures. I want userA to see only measure 1, and want userB to see both measures. How do I achieve this? (via Section access or front end. 

Thank you. 

[Or]

You don't.

You can hide measures using visibility conditions, but this is not security. Have a look at using OSUser() to find out who the user is.

On the back end, you can only restrict back-end fields (using Omit) and rows (using Section Access). If you want one of your users to not see costs, use OMIT on the cost field.

[Bob07]

Thank you @Or  for the prompt response. I tried to use the omit function but couldn't get it to work. Ths is a snapshot of my scenario. I have two calculated measure (priceA & priceB). I have a section access file with Access, User.Email, Omit. My aim is for userA to see priceA, userB to see only priceB, and userC to see all prices. Please help. Thank you.

[Or]

There's a good documentation page for Section Access and OMIT, as well as a fair number of posts in this community.

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m...

As I said, you can't OMIT a measure. You would have to OMIT the underlying field it's calculated from. In your case, that would seemingly be %GM or %Target (if those are fields rather than calculations).