topic Preventing selections being saved in documents in QlikView

Preventing selections being saved in documents

Tue, 19 Apr 2011 16:14:00 GMT

Hello

Occassionally someone makes a mod to a document and forgets to clear the selections and set the view back to the first page, then saves it. Does anyone know how I can prevent selections being saved in documents and ensure the first page is always shown when the users enter the application?

Thanks!

Preventing selections being saved in documents

IAMDV — Tue, 19 Apr 2011 16:18:43 GMT

You can use Events & Triggers to Unclear the selections....

Preventing selections being saved in documents

erichshiino — Tue, 19 Apr 2011 16:19:55 GMT

Hi,

I don't know if it is easy to prevent to save it in the way you want, but you could clear everything and go to the right sheet using triggers:

Go to triggers (Settings ->document properties - > Triggers) and select the 'OnOpen' event.

There, include a clearAll and Layout -> Activate Sheet

Include the sheet ID (you can find the ID on the sheet properties)

Preventing selections being saved in documents

Tue, 19 Apr 2011 16:27:11 GMT

Hi,

One solution could be, write a macro to clear all selections and activate your 1st sheet and map this function to "OnOpen" Trigger. So when ever the application is opened, Trigger would be fired and call the marco to clear the selection and activate the 1st sheet.

Your mode code should be something like below

Sub OnOPenDoc

ActiveDocument.ClearAll false

ActiveDocument.ActivateSheetByID "SH01"

End Sub

Hope this may helps you

- Sridhar