Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zagzebski
Contributor

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

Tags (2)
14 Replies
awhitfield
Esteemed Contributor

Re: Table (excel export)

Can you upload your qvf?

point 2 right click and export data.

zagzebski
Contributor

Re: Table (excel export)

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

Image.PNG

phaneendra_kunc
Valued Contributor III

Re: Table (excel export)

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
Contributor

Re: Table (excel export)

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

awhitfield
Esteemed Contributor

Re: Table (excel export)

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

zagzebski
Contributor

Re: Table (excel export)

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
Valued Contributor

Re: Table (excel export)

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

phaneendra_kunc
Valued Contributor III

Re: Table (excel export)

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
Contributor

Re: Table (excel export)

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

Steve