I have certain users that are not allowed to see a field from my fact table. I have used the OMIT field in section access to omit this field from the fact when the user opens the QlikView document. This works excellent.
My problem is in a chart that I am showing. One of the expressions in the chart uses the omitted field. Even when the field is omitted it still shows the measure in the legend. I want to get rid of the measure in the legend when the field is not present in the fact.
Let's assume that the measure that can be omitted is named [My measure]. The chart shows the sum of that measure: SUM([My measure]). Right now I use the following expression to hide the chart-expression when it is not present in the fact: