topic Re: How can we restrict a measures for specific metric. in QlikView

How can we restrict a measures for specific metric.

sbethalam — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Since I am new to this and I would like your suggestions.

We have implemented a security in qlikview and working fine, but we wanted to enhance the security and would like to restrict few measures for specific metrics.

Let's assume that, we have two metrics, Sales and Revenue. For Sales, I would like to show all measures and for Revenue, I would like to show only one measure like (Revenue Percentage).

Since we are maintaining all measures in excel sheet and I would like to restrict either in excel sheet or sheet level.

Please let me know if I am not clear.

Thanks

Srinath

Re: How can we restrict a measures for specific metric.

Mark_Little — Wed, 18 Nov 2015 17:22:03 GMT

Hi,

To be able to advise better I would need to understand how your currently applying the Section Access or security. It will be possible to achieve either with conditional show and hide on columns or have two table which are conditional. But need more info

Mark

Re: How can we restrict a measures for specific metric.

JonnyPoole — Wed, 18 Nov 2015 19:13:08 GMT

With Section Access you can use the OMIT field to name fields in the data model that specific users or groups should be prevented from seeing.

Re: How can we restrict a measures for specific metric.

sbethalam — Thu, 19 Nov 2015 18:27:17 GMT

Hi Mark,

Thank you very much for your reply, I can defiantly share the information personally. Please let me know your email so that I will communicate.

Thanks in advance.

Srinath

Re: How can we restrict a measures for specific metric.

sbethalam — Thu, 19 Nov 2015 18:28:31 GMT

Hi Jonathan,

Thanks for your reply, I will try on this.

Regards

Srinath