topic Re: how to get current selection get's exported in QlikView

how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:10:41 GMT

i'm using qlikview 11

and my user want current selection to be exported in excel

in the ihave enables the export setting option in user preferences

settings--> user preference -->export --> on BIFF export

it working from qlikview desktop side

but still i don't see while exporting from access point

what options needs to be enabled

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:13:04 GMT

we are using ajax plugin and IE browser

Re: how to get current selection get's exported

shree909 — Fri, 30 Nov 2012 18:13:28 GMT

Hi do u want to export all the current selections into excel or a particular chart or something..

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:14:24 GMT

all current selections are needed to exported when we export a staright table

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:27:14 GMT

I'm not sure about the AJAX, but in IE you can do this:
Press Alt+Ctrl+U to get to the User preferences, and check "On BIFF Export".

Regards,
Michael

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:30:54 GMT

thanks for the reply,

this option is enabled and it's working when we export object(straight table) we can see cureent selection in the bottom

but the same application (but from IE browser ) when you export it does not show the current selection

why is it so ? is it a bug ?

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:35:15 GMT

This is not a "Document" property, it is a "User" property. That means this settings are not stored as a part of application.

Next, the settings you made in Desktop have nothing to do with the settings in IE plugin - they are to different entitirs, hence you need to configure both.

Regards,

Michael

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:39:31 GMT

i'm not that expert in qlikview

can you please help in fixing this issue

how do i configure the IE setting to get current selections exported ?

or is there a way that my end user can see there selection list when exported (in this case)?

do you have any suggestion/ideas

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 18:53:21 GMT

Follow these steps:
Open a QV application in IE. Click anywhere on a background to make sure the application is active. Press Ctrl+Alt+U to bring User Preferences for QV IE Plugin. On the tab Export, check "On BIFF Export". Click OK.
Repeat the above on each user machine. Not for each application, because it is per user.

Regards,
Michael

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 19:09:35 GMT

For some reason i could not open user preferences from IE browser (i'm using IE browser). but my plugin is AJAX,

if it not works with ajax, then is there any other ways that we can fix this issue.

Really, thank you so much for your patience

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 19:18:08 GMT

You cannot open User Preferences exactly because you use AJAX client. As I've mentioned in my first response, I'm not sure if this export is possible in AJAX, sorry. My suggestion was explicilty for QV IE Plugin.

Can't you use QV IE Plugin instead AJAX?

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 19:23:03 GMT

Thanks for your patience and all your suggestion.

I Can suggest them , but not sure whether they change from Ajax/IE.

but i strongly feel that this issue has to be addresed in a better way (by qlikview side)

because every user wants to see there selection in excel export and a default option has to be inculded in document properties

Thanks

Have a good day

Re: how to get current selection get's exported

Anonymous — Fri, 30 Nov 2012 19:32:57 GMT

Try to go to the "Ideas" section and submit an idea.

Maybe if you're lucky the solution exists already, so you'l get a better response.

Regards,

Michael