topic Re: Current selection written in Excel export in QlikView

Current selection written in Excel export

sergio0592 — Sat, 10 Sep 2016 15:19:53 GMT

Hi all,

I'am looking for get a page header with the current selection written, in my Excel document.

Ex: current selections --> Shop=B, Year=2015.

Is there a simple way to achieve that? Or we need use macro?

Regards

Re: Current selection written in Excel export

Nicole-Smith — Sat, 10 Sep 2016 18:19:42 GMT

I'm not sure how to get it at the top, but you can get it at the bottom by following these instructions: Export Current Selections to Excel by Default

Re: Current selection written in Excel export

sergio0592 — Mon, 12 Sep 2016 08:39:36 GMT

Thanks Nicole for your reply. But these settings will impact all .qvw and i'd like to get this only for one .qvw

Re: Current selection written in Excel export

Mon, 12 Sep 2016 12:27:53 GMT

In the Export tab of the User Preferences you can select the On BIFF Exports. This worked for me.

- Stan

Re: Current selection written in Excel export

sergio0592 — Mon, 12 Sep 2016 17:14:02 GMT

Nice, it works!! But unlucky the line is at the bottom, not on top.

Re: Current selection written in Excel export

Nicole-Smith — Mon, 12 Sep 2016 17:51:26 GMT

I'm pretty sure "User Preferences" only affects the user who has that setting on their computer. I do not think the setting will carry over to other users or to the server. It's not a document level setting.

Re: Current selection written in Excel export

Tue, 13 Sep 2016 02:26:07 GMT

Nicole is correct and this will only affect you. It will also affect all qvw that you view on your desktop. You will need to change the User Preferences each time you want to use this qvw and then change it back when you are done.

What is the exact need you have? Do you need all users of this qvw to see the Selections in the Excel. Or are you the only one that needs the Excel to include the selections?

- Stan

Re: Current selection written in Excel export

sergio0592 — Tue, 13 Sep 2016 06:47:46 GMT

My need is for all users of this .qvw.

Re: Current selection written in Excel export

Tue, 13 Sep 2016 16:12:04 GMT

Will the users bringing in a copy of the qvw to their desktop, or will they be accessing via a browser thru Access Point?

Re: Current selection written in Excel export

sergio0592 — Tue, 13 Sep 2016 19:05:14 GMT

All users will access with browser through Access Point.

Re: Current selection written in Excel export

Wed, 14 Sep 2016 02:12:43 GMT

If they were pulling the qvw down to their desktop, you might have been able to temporarily change the settings.ini file on the user's machine to get the desired outcome.

However, since they are accessing via Access Point it is using the settings.ini on the QlikView server, which will not work for you.

The only other thought is to create a macro. However, macros will not work when the qvw is accessed via Access Point. That is, unless, you are using the IE plugin. Not sure if you are familiar with the IE plugin, but it would give you more of the functionality as if the qvw is running on the desktop. The drawback with the plugin is that it has to be installed on each client.

IE Plugin Vs Ajax Client

Wish I had a better answer,

- Stan