Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jblomqvist
Contributor II

Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

Hi all

Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

For example I have a SalesAmount field.

For some charts, for some users I want to show the result of Sum(SalesAmount) where it exceeds 100,000 in value otherwise display 0.

So out of 10 users who have access to the application, for some users I want them to see all the values, but for others I want them to only see results where Sum(SalesAmount) exceeds 100,000.

Is this possible?

2 Replies
Employee
Employee

Re: Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

Hi John,

Never tried to use an if statement in section access. However, you can have two charts on top of each other and enable the one for a certain users with a calculation Condition.

Bill

stigchel
Honored Contributor

Re: Is it possible to use the OMIT function in Section Access with a IF statement for some kind of condition?

As far as I know not, but you can create an access field e.g. FILTER for those users and use something like

if(FILTER='Y',

Alt(Sum({<Product={"=Sum(Sales)>=100000"}>}Sales),0),

Sum(Sales)

)

Example attached

Community Browser