Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan2391
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
Frank_Hartmann
Master II
Master II

see attached.

hope this helps

View solution in original post

5 Replies
trdandamudi
Master II
Master II

Please see the attached and hope this helps..

simospa
Partner
Partner

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

S.

sbobbyraj
Creator III
Creator III

Hi,

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

Kind regards

mohan2391
Creator II
Creator II
Author

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 ?

Frank_Hartmann
Master II
Master II

see attached.

hope this helps

View solution in original post