Trick #2: A user-selectable default sheet.
If you have clients who share a QlikView document but who like to select a personal "favorite" sheet that the document always opens up on. Here's one way to do that.
First, edit your document's script and create a table of available sheet names and, if your sheet IDs are not the same as the sheet names, add corresponding sheet IDs.
SheetList:
load * inline [
%default_sheet_name, %default_sheetID
Dashboard, SH101
Executive Summary, SH_EXEC
Reports, Report_sheet
Preferences, PREF_SHEET
];
Note that the sheet IDs above are completely made up and would be replaced with actual sheet IDs obtained from your sheets' Properties tabs. I highly recommend changing your sheet IDs to meaningful names, it makes referencing them in things like the Expression Viewer much easier. I use the '%' prefix on the field names because I really don't care for these values to show up in Current Selection objects.
Create a List Box object to expose %default_sheet_name values. I recommend doing this on a Preferences sheet.
Select a value from this list box and then enable the 'Always one selected' property on the list. This will also make your client's selection immune to the Clear button and Clear All actions.
Next go into Document Properties->Triggers and add an OnOpen trigger of type Layout->Activate Sheet and specify %default_sheetID.
In the near future I'll tell you how to "bullet proof" this so that the client selection doesn't get reset by the QlikView.
Subscribe to:
Posts (Atom)
No comments:
Post a Comment