How to Display initial sheet based on User profile?
Hello,
I have a question in displaying startup sheet based on user profile.
For Ex. Qlikview application has 5 sheets as sheet1, sheet2, ..sheet5. when UserA opens Qlkiview application he/she should login to default Sheet2, for UserB should login to Sheet3 and so on. After that users does not have any restriction accessing sheet.
How can I implement this functionality. Any ideas would be appreciated.
I'm not sure if you are having the issue within set analysis or if you are trying to direct a user to a default tab based on login. Either way, the same type of code should work. Note that all of my work is based on the AJAX client and its limitations, which include a limited ability to utilize macro code. So I'm not using macros at all, just formulas in either set analysis on an expression or in a Conditional Show Sheet setting.
For set analysis, we are using a formula like this: Count({$<vUserName = {$(=QVUSER())}>} SomethingToCount). We are using this in our app because our application requires comparison of a user's data against the entire population of users. As a result we cannot use dynamic data reduction to restrict the data that a user sees, otherwise we'd lose the ability to show the comparison against the full set. We are presenting our app via the web, so we don't have OSUSER() available. But QVUSER() works. The syntax within set analysis was a bit tricky, but the sample above should work for you.
If you want to have a user see a subset of the tabs, you can use a similar expression in the Conditional formula of the Sheet Properties. See Show Sheet under the General tab. I am no longer using this technique, so I'm not exactly sure of the syntax. Something like this ought to do it, though: vUserName = QVUSER().
One thing you may run into in your testing is that you have to publish your app to AJAX then authenticate to it in order to set the QVUSER() variable. That's been a bit of a challenge for me, since I can't test the QVUSER() formulas directly in Developer, but I've worked around it.
