Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
LauraMorris
Contributor III
Contributor III

Different opening sheet for different users

I want to  have the app open on a different sheet for different user groups. I know I can set which sheet it opens with by using a bookmark but this is the same for all users.

Labels (1)
1 Solution

Accepted Solutions
Hania
Creator
Creator

Hii

You can create the sheet group :

here I have create inline table in section access for Different department  and assign the department to different user  and then create the sheet group  as.

Table_name:
Load * Inline [
DEPT,GroupSheet
IT,100100
FINANCE,010010
ALL,111111
SALES,001001 ];

after that you need to  set sheet condition as mid(GroupSheet,1,1)  assign it to user you want.

here mid(GroupSheet,1,1) second parameter is your sheet number

View solution in original post

2 Replies
Chanty4u
MVP
MVP

Hania
Creator
Creator

Hii

You can create the sheet group :

here I have create inline table in section access for Different department  and assign the department to different user  and then create the sheet group  as.

Table_name:
Load * Inline [
DEPT,GroupSheet
IT,100100
FINANCE,010010
ALL,111111
SALES,001001 ];

after that you need to  set sheet condition as mid(GroupSheet,1,1)  assign it to user you want.

here mid(GroupSheet,1,1) second parameter is your sheet number