Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Send To Excel: Should show hided fields as well

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).

issue.PNG

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

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

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

see attached.

hope this helps

View solution in original post

5 Replies
Highlighted
Master II
Master II

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

Please see the attached and hope this helps..

Highlighted
Partner
Partner

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

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

S.

Highlighted
Creator III
Creator III

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

Hi,

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

Kind regards

Highlighted
Creator II
Creator II

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

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 ?

Highlighted
Master II
Master II

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

see attached.

hope this helps

View solution in original post