Discussion Board for collaboration on QlikView Scripting.
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.
Solved! Go to Solution.
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.
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?
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.
Sent from my iPhone