Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Table (excel export)

I am new to Sense. I have two issues and could not find answers in the community.

1. I created a Pivot table that when fully expanded goes beyond the screen. However I do not have any scroll bars and can't find where to turn them on.

2. I made a table out of my Pivot table and I do not see anywhere to export to excel. When I right click on the table there is no option to copy (like in QlikView)

Thanks for the help,

Zag

14 Replies
awhitfield
Partner - Champion
Partner - Champion

Can you upload your qvf?

point 2 right click and export data.

zagzebski
Creator
Creator
Author

This is what I get when I right click on the table

Image.PNG

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Looks like you are in a diff screen resolution. The menu you are seeing usually pops up on ipad's or mobile.

Also older versions of qlik sense doesnt have a capability to "export to excel" pivot tables. Atleast in 2.0.x versions.

Try using 2.2.x Feature releases or 3.0 Service Release.

zagzebski
Creator
Creator
Author

I just loaded the Desktop version (3.0) and I am still not getting the excel option.

awhitfield
Partner - Champion
Partner - Champion

So, do you get the 'Export Data' option?

zagzebski
Creator
Creator
Author

No I still get the options that I had in my previous image, not the options you have in your image. Very frustrating as

I need to get some data into excel.

Zag

TKendrick20
Partner - Specialist
Partner - Specialist

On mine, I just click the ellipses (...) and then "Export Data" and it downloads a .xlsx file.

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

This definitely looks like a resolution/device issue. what device are you using?

is it  windows or mac or ipad?

Usually in windows you will below when you right click.

8-1-2016 10-16-05 AM.png

Where as on mobile (not sure on MAC) this is how it displays when you tap and hold on any chart. "Clicking on three dots "..." will give more options in which you can find export option as well.

8-1-2016 10-16-15 AM.png

zagzebski
Creator
Creator
Author

That is strange because I am using a brand new Dell computer.

Steve