Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
robbybalboa
New Contributor III

OMIT - partial usage

Dear User group

Is it possible to create OMIT depending to one data value of one field.

Example

DATA:

Country Sales Cost of Sales
US 100 50
FR 50 20
PL 20 5


USER A allowed to see all data
USER B allowed to see only cost of Sales for Country FR
but allowed to see sales from all countries
--> therefore section access by row not possible


Thank you in advance for your comments and ideas.
Rob

6 Replies
Not applicable

OMIT - partial usage

take a look at:

http://community.qlik.com/blogs/qlikviewblogs/archive/2010/06/10/introduction-to-qlikview-section-access.aspx

Luminary
Luminary

OMIT - partial usage

Rob,

If you can send me your direct email address I have a working solution for this situation (Section Access Plus as I call it) - I can't post it here as it needs both a .qvw and an Excel sheet to control the permissions.

I'm looking to post it to the 'Share Qlikview's' shortly but that may be a few weeks away.

All the best,

Matt - Visual Analytics Ltd

robbybalboa
New Contributor III

OMIT - partial usage

Hi Matt,

thanks. Just a stupid question - it's my first posting.
How could I send you my email adress?

Robt

Not applicable

Re: OMIT - partial usage

Hi Rob,

I know it has been a long time since you had this problem. But right now I am having a similar issue and I haven't found any answers so far. Could you please help me and tell me how you have solved your problem?

Many thanks in advance!

Steffi

robbybalboa
New Contributor III

Re: OMIT - partial usage

Hallo Steffi,

leider keine Lösung gefunden.

Unfortunatly I have no solution for this question.

Gruß

Robert

Not applicable

Re: OMIT - partial usage

Hallo Robert,

schade. Vielen Dank für Deine Antwort!

Grüße

Steffi