topic Re: Hide a field in QlikView

Hide a field

Fri, 12 Dec 2014 07:35:19 GMT

Dear Experts,

I am generating a sales and profit report.

I need to distribute the file for different departments.

I want to hide the profit from certain department; I want the same report for CEO and marketing but the CEO see the gross profit where as the marketing do not see the gross profit.

How can I do it?

Thank you.

Re: Hide a field

Fri, 12 Dec 2014 07:41:30 GMT

could you attach sample app

so that it would be more clear

Re: Hide a field

tresB — Fri, 12 Dec 2014 07:48:44 GMT

Do you have publisher? If yes, you could reduce the application and distribute accordingly. Else, section access could be the option. And it doesn't seem to be a case of hiding a field.

Re: Hide a field

Fri, 12 Dec 2014 07:55:03 GMT

This is a sample of my data.

I don't want the red dot (gross profit) to appear when the file is distributed to the marketing.

Yes I have the publisher; tresesco can you please explain more about the options you mantionned?

Thank you

Re: Hide a field

tresB — Fri, 12 Dec 2014 09:05:37 GMT

So you need to hide an expression. One easier idea could be using qvuser() (if using section access) or osuser(). Expression enablement condition for gross profit expression would be like:

=Osuser()= 'CEOuserid'

Re: Hide a field

Fri, 12 Dec 2014 09:15:27 GMT

Sorry tresesco but I am very new to Qlikview I did not understand your answer.

What is section access?

What does =Osuser()= 'CEOuserid' mean?

Gross profit is a field that I am reading from the database in Load statement so I want something that will disable the read of this field so the field will not display in all reports.

Re: Hide a field

tresB — Fri, 12 Dec 2014 09:23:38 GMT

For section access, download the pdf from: here . You could use OMIT to make a field invisible from users.