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: 
Not applicable

Open Qlikview different sheets depending on user

Hi

I want to know wheter it is possible to have a qlikview cloud open on a certain sheet depending on the user who opens the qlikview cloud

I have two users 'TSC' and 'RS'

1) Upper(OSUser())='TSC'

2) Upper(OSUser())='RS'

When TSC opens my Qlikview cloud i want that Qlikview opens on the sheet 'Retail'.

When RS opens my Qlikview cloud I want that Qlikview opens on the sheet 'Sales'

Yet both have to be able to see both sheets.

1 Solution

Accepted Solutions
Partner
Partner

Hi Tim,

I would suggest using a document action to activate the correct sheet.

  • Open document properties (Settings -> Document Properties)
  • Open tab Triggers
  • Choose OnOpen in Document Event Triggers
  • Choose Add Actions (or Edit Action(s) if you've already got actions defined)
  • Select Add
  • Under Layout, choose Activate sheet
  • For Sheet ID, enter =If(Upper(OSUser())='TSC', 'Retail', 'RS')

Check that the sheet ID's (not the names) are to be used here.

OpenSheetForUser.png

Hope this helps you.

Kind regards,

Ronald

View solution in original post

3 Replies
Partner
Partner

Hi Tim,

I would suggest using a document action to activate the correct sheet.

  • Open document properties (Settings -> Document Properties)
  • Open tab Triggers
  • Choose OnOpen in Document Event Triggers
  • Choose Add Actions (or Edit Action(s) if you've already got actions defined)
  • Select Add
  • Under Layout, choose Activate sheet
  • For Sheet ID, enter =If(Upper(OSUser())='TSC', 'Retail', 'RS')

Check that the sheet ID's (not the names) are to be used here.

OpenSheetForUser.png

Hope this helps you.

Kind regards,

Ronald

View solution in original post

Master II
Master II

you may put this as trigger in Document Properties -> Triggers -> Document Event Triggers -> On Open.

Peter

MVP
MVP

On Open -> Activate Sheet:

Capture.PNG