Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

How to hide one of the dimension to avoid user view confidential report.

Hi All

I have a dimension with 30 field.

May i know how to hide one of the dimension "_DESC" ? So that user are unable to click on this field and drill in to view the report , only i am allow to click on this .

Because if they are able to click on the _DESC as dimension , they can view some of the confidential information.

Paul

1 Solution

Accepted Solutions
krishnamraju513
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

In Section Access you can use OMIT for the Particular user to avoid him to see _DESC Dimension .

7 Replies
paulyeo11
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

my QV Doc

sunny_talwar
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

One solution could be to use this if statement for the expression:

=If([Pls select 101st Dim] <> '_DESC', [Pls select 101st Dim])

But the issue remains that the option is still available and if someone creates a new list box for [Pls select 101st Dim] then they will still see _DESC. The only way to remove that would be to remove it during the load so that it is just not available in the application.

HTH

Best,

Sunny

krishnamraju513
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

In Section Access you can use OMIT for the Particular user to avoid him to see _DESC Dimension .

briancopple
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

Hi Paul

If you are talking about a dimension within a table could you not clone the table and then restrict which table the user sees based on their login via section access?

Kindest Regards

Brian

paulyeo11
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

Hi Sunny

Thank you very much for your sharing , while driving back After my dinner , I found a solution , that is I will use mapping to recode all those sensitive field into one common word like salary , so that user even drill in unable to view the detail break down. So it is okay.

Paul

Sent from my iPhone

paulyeo11
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

Good suggestion.

Sent from my iPhone

paulyeo11
Not applicable

Re: How to hide one of the dimension to avoid user view confidential report.

Thank you for the suggestion. I will try it out

Sent from my iPhone