topic Export selections on some fields to excel in QlikView

Export selections on some fields to excel

Tue, 29 Apr 2014 11:55:21 GMT

Hi All,

I have a requirement to export what a user has selected to excel (or copy to clipboard).

As an example, let's say I have the following fields that can be selected:

SWITCH_1

SWITCH_2

FIELD_1

FIELD_2

FIELD_3

I thought it would be possible to somehow 'hack' together a straight table (or whatever works) to show the following:

Header 1	Header 2
FIELD_1	bob,granny.leslie
FIELD_2	UK,USA,Argentina,Canada
FIELD_3	M,F

I would then be able to export this to excel.

Has anyone achieved this? It seemed quite simple in my head but now coming to actually producing it I'm finding it much more difficult.

The current selections box that is built in doesn't really work for me because I have loads of fields that act as switches etc...

Cheers,

GPC

Re: Export selections on some fields to excel

its_anandrjs — Tue, 29 Apr 2014 11:59:51 GMT

Please explain more or otherwise you can do this with the adhoc reports where you can see in the qlikview samples.

Re: Export selections on some fields to excel

Tue, 29 Apr 2014 15:06:40 GMT

Hi Anand,

Sorry - what was not clear? Essentially I am looking for a way to export the current selections to clipboard/file or excel while being able to customise the format.

Please can you point me in the direction of the specific examples you refer to?

Cheers,

GPC