topic Re: Send To Excel: Should show hided fields as well in QlikView

Send To Excel: Should show hided fields as well

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have a straight table, in that i have added 20 dimensions and 1 expression.

Out of those 20, i have selected only 7 dimensions as showed dimensions and have hided the rest 13 with the option available in presentation layer (below is the screenshot).

Now, the issue is:

when i click on "Send to Excel" (icon on chart - top right along with minimize,maximize), the excel is showing only the 7 dimensions and 1 expression, which i have made showed columns.

So, how to get the rest of the dimensions also in the excel..
Basically I want to show 7 dimensions & 1 expression in chart and want to see 20 dimensions and 1 expression in excel when they click on 'Send to Excel'

Is this possible, if yes, how ?

Thanks

Re: Send To Excel: Should show hided fields as well

trdandamudi — Tue, 18 Sep 2018 12:26:21 GMT

Please see the attached and hope this helps..

Re: Send To Excel: Should show hided fields as well

simospa — Tue, 18 Sep 2018 13:56:02 GMT

You could use a macro, if you are using this .qvw with IE plugin or via Local Client.

Re: Send To Excel: Should show hided fields as well

Anonymous — Tue, 18 Sep 2018 16:02:44 GMT

Hi,

You must use a macro, with the send to Excel button you can only export what you show see on screen.

Kind regards

Re: Send To Excel: Should show hided fields as well

mohan2391 — Tue, 23 Oct 2018 05:13:16 GMT

Hi Thirumala,

Thanks!!

How did you achieve this ?

I am seeing the hided column also in the excel..

Did you use macro for this or is this a built in feature ?

Re: Send To Excel: Should show hided fields as well

Frank_Hartmann — Tue, 23 Oct 2018 09:55:42 GMT

see attached.

hope this helps