Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.