Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
karin_nevo
Contributor III
Contributor III

Limit export to excel option

HI,

I have a chart with a large number of rows (65,000) and when trying to export it to excel can take 5-10 minutes.

Is there a way to display the export option using a condition (for example, only if number of rows < 10000 or if specific field was selected)?

thanks,

Karin

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

You could hide the icon by making two copies of the chart and display them conditionally to show the icon when < 10000 and switch when the count > 10000 to the copy without the icon.

This will however not prevent users exporting via a right click,

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

You could hide the icon by making two copies of the chart and display them conditionally to show the icon when < 10000 and switch when the count > 10000 to the copy without the icon.

This will however not prevent users exporting via a right click,

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
karin_nevo
Contributor III
Contributor III
Author

Good idea, Thanks.