Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Section Access Problem

Hi All

I have a document with different Access for users.

I have 3 sheets. and a field paylocationId with 2 values 6007 and 6397.

User A should be access Sheet 1 with ID 6397

User B should be access Sheet 2 with ID 6007

User B should be access Sheet 2 with ID 6397 and 6007.


I should add expression in conditional show sheet. what should I add?!!


7 Replies

Maybe is approach will work?

Help with conditional show of a test objectth

Partner
Partner

You can't apply diffrent section access by sheet, but if you first do your section access allowing

A to see 6397

B to see 6397 and 6007

you can tweak the presentation to only calculate for the desired accounts.

create a access matrix similar to this giving sheet1 value 1 if the user is allowed to see the account on that sheet.

User paylocationId Sheet1 Sheet2
A639710
B639701
B600711

On each sheet put the set {<SheetX={1}>} in your expression.

Section Access Problem by marjan bakhtiari.PNG

See attached file.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Creator III
Creator III

No Its not good for me. I have 3 group people not 3 people.

Partner
Partner

Hi Marjan,

     In Sheet --> Properties --> General --> Show sheet --> Select Conditional --> write below code and try it

For Sheet 1

=IF(GetFieldSelections(User)='A' and GetFieldSelections(PaylocationID)='6397',1,0)

For Sheet 2

=IF(GetFieldSelections(User)='B' and GetFieldSelections(PaylocationID)='6007',1,0)

For Sheet 3

=IF(GetFieldSelections(User)='B' and (GetFieldSelections(PaylocationID)='6397' or GetFieldSelections(PaylocationID)='6007'),1,0)

Creator III
Creator III

I want this matrix

UserpaylocationIdSheet1Sheet2Sheet3
A6397100
B6007010
c63970
0
1
C6007001

for Sheet 1 we can add conditional =paylocationId=6397

for Sheet 2 we can add conditional =paylocationId=6007

for Sheet 3 we can add conditional =?????????????

Partner
Partner

No I don´t think it is a good idea to put conditional shows on the sheets with this logic. If you add sheet3 then you should add the {<Sheet3={1}>} on all the expressions on sheet 3.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Partner
Partner

I think I understand your problem a bit better now. Take a look at this attached application where I've implemented conditional show on the tabs.

Section Access Problem by marjan bakhtiari.PNG

Plees ekskuse my Swenglish and or Norweglish spelling misstakes