topic Re: Default selection for pivot table in QlikView

Default selection for pivot table

Mon, 14 Oct 2013 10:42:19 GMT

Hi All,

I like to have a default selection whereby when the qvw is open, the selection is always at Organisation as shown in Default.jpg. I thought I can use triggers in properties but it doesn’t seems to work for me. Please can you help?

Many Thanks!

Regards,

Heok

Re: Default selection for pivot table

Mon, 14 Oct 2013 10:50:01 GMT

pfa hope it will help

Regards

nirmal

Re: Default selection for pivot table

Aurelien_Martinez — Mon, 14 Oct 2013 10:56:59 GMT

Hi Heok,

In Document properties you can add trigger like that :

After change, save your QV file, close and reopen it.

Normaly it's working

Regards,

Aurélien.

Re: Default selection for pivot table

rustyfishbones — Mon, 14 Oct 2013 10:59:37 GMT

Create a Bookmark

and then create an On Open trigger and call the Bookmark

Re: Default selection for pivot table

Mon, 14 Oct 2013 11:02:29 GMT

pfa

Re: Default selection for pivot table

Mon, 14 Oct 2013 11:43:00 GMT

Thanks for your screen shot. I add the action in the document properties and work now. I was adding the action to the sheet properties that's why it was not working early. Thanks again!