Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Can you upload your qvf?

point 2 right click and export data.

Highlighted
Creator
Creator

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

Image.PNG

Highlighted
Partner
Partner

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.

Highlighted
Creator
Creator

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

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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

Steve